Helpful IBM i Tips and Techniques Presented by Laura and Community Members

A collection of helpful tips and techniques for IBM i users, shared by Laura and other community members. The tips cover topics such as managing disk utilization, utilizing the QADBIFLD file for system information, and a command created by Greg Shefferly to find source code efficiently. Includes practical examples and images for better understanding.

• IBM i Tips
• Techniques
• Disk Utilization
• QADBIFLD File
• Source Code

bmose Follow

Uploaded on Oct 02, 2024 | 0 Views

Download Presentation

Please find below an Image/Link to download the presentation.

The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.

Presentation Transcript

1. IBM I TIPS AND TECHNIQUES A HODGE PODGE OF HELPFUL IBM I INFORMATION PROVIDED BY LAURA AND OTHER COMMUNITY MEMBERS PRESENTED BY LAURA

2. TIP 1 RTVDSKINF QAEZDISK PROVIDED BY LAURA HELPS MANAGE DISK UTILIZATION WRKSYSSTS SHOWS DISK UTILIZATION THIS EXAMPLE 93.6328% SPACE IS USED

3. TIP 1 RTVDSKINF QAEZDISK PROVIDED BY LAURA RTVDSKINF UPDATES FILE QAEZDISK CAN BE RUN FROM COMMAND LINE OR FROM THE JOB SCHEDULER

4. TIP 1 RTVDSKINF QAEZDISK PROVIDED BY LAURA GO DISKTASKS OPT 1 RTVDSKINF OPT 2 PRTDSKINF RTVDSKINF CREATES QAEZDISK PRTDSKINF PRINTS A REPORT WITH OPTIONS *LIB *FLR *OWN *OBJ OR *SYS

5. TIP 1 RTVDSKINF QAEZDISK PROVIDED BY LAURA CAN USE QUERY, SQL OR PRTDSKINF REPORT CAN BE SCHEDULED TO RUN ON A REGULAR SCHEDULE AND CAPTURED AWESOME FOR ANALYSIS OF DISK UTLIZEATION

6. TIP 1 RTVDSKINF QAEZDISK PROVIDED BY LAURA EXAMPLE REPORT

7. TIP 2 QADBIFLD PROVIDED BY LAURA THE QADBIFLD FILE IN QSYS LIBRARY CONTAINS ALL THE FILES AND FIELDS ON THE SYSTEM. VERY USEFUL! THERE ARE SEVERAL FILES STARTING WITH QADB WITH INFORMATION ON ALL FILE AND VIEW INFORMATION AND MORE QADBCCST *FILE QSYS PF CONSTRAINT FIELD USAGE INFO QADBFCST *FILE QSYS PF FILE LEVEL CONSTRAINT CROSS QADBFDEP *FILE QSYS PF CROSS REFERENCE DEPENDENCY QADBIFLD *FILE QSYS PF CROSS REFERENCE PHYSICAL FI QADBKFLD *FILE QSYS PF CROSS REFERENCE PHYSICAL FI QADBPKG *FILE QSYS PF SQL PACKAGE PHYSICAL FILE QADBXMQT *FILE QSYS PF QADBXRDBD *FILE QSYS PF QADBXREF *FILE QSYS PF QADBXSFLD *FILE QSYS PF QADBXTRIGB *FILE QSYS PF QADBXTRIGC *FILE QSYS PF QADBXTRIGD *FILE QSYS PF

8. TIP 3 FIND COMMAND CREATED BY GREG SHEFFERLY HELPS FINDING SOURCE CODE CONSISTS OF CMD, DSPF AND SQLRPGLE

9. TIP 3 FIND COMMAND CREATED BY GREG SHEFFERLY HELPS FINDING SOURCE CODE

10. TIP 3 FIND COMMAND CREATED BY GREG SHEFFERLY HELPS FINDING SOURCE CODE

11. TIP 3 FIND COMMAND CREATED BY GREG SHEFFERLY HELPS FINDING SOURCE CODE

12. TIP 4 CVTRPGSRC PROVIDED BY LAURA CONVERT FROM RPG TO RPGLE CVTRPGSRC ENTER VALUES IN THIS EXAMPLE RPG PROGRAM CHECKDAT IS CONVERTED FROM RPG TO RPGLE CHECKDAT1

13. TIP 4 CVTRPGSRC PROVIDED BY LAURA CONVERT FROM RPG TO RPGLE AFTER CONVERTED THE PROGRAM CAN BE COMPILED, IT S THAT SIMPLE! GREAT TO UPDATE OLD CODE TO NEW CODE.

14. TIP 5 CPYSPLF PROVIDED BY LAURA COPY THE CONTENTS OF A SPOOL FILE TO A PHYSICAL FILE FIND THE ATTRIBUTES OF THE SPOOL FILE YOU D LIKE TO COPY TO A PHYSICAL FILE

15. TIP 5 CPYSPLF PROVIDED BY LAURA COPY THE CONTENTS OF A SPOOL FILE TO A PHYSICAL FILE CREATE THE FILE SAME WIDTH AS SPOOL FILE

16. TIP 5 CPYSPLF PROVIDED BY LAURA COPY THE CONTENTS OF A SPOOL FILE TO A PHYSICAL FILE COMPLETE THE COPY USING THE SPOOL FILE ATTRIBUTES TO IDENTIFY THE SPOOL FILE BEING COPIED

17. TIP 5 CPYSPLF PROVIDED BY LAURA COPY THE CONTENTS OF A SPOOL FILE TO A PHYSICAL FILE THE FILE CAN BE QUERIED USING SQL OR QUERY400, USED BY A CL OR RPG OR WEB APPLICATION

18. TIP 6 PRINTING TO LOCAL PRINTER PROVIDED BY LAURA PRINT TO YOUR REMOTE PRINTER CONFIGURE CLIENT ACCESS PRINTER SESSION CREATES OUTQ

19. TIP 6 PRINTING TO LOCAL PRINTER PROVIDED BY LAURA PRINT TO YOUR REMOTE PRINTER OUTQ CREATED WITH NAME DESIGNATED

20. TIP 6 PRINTING TO LOCAL PRINTER PROVIDED BY LAURA PRINT TO YOUR REMOTE PRINTER SESSION HAS TO BE STARTED TO PRINT

21. TIP 7 SERIAL NUMBER AND PROCESSOR PROVIDED BY LAURA QUICKLY FIND BOX INFO WRKLICINF SHOWS BOX SERIAL NUMBER SHOWS PROCESSOR GROUP

22. TIP 8 BOX MODEL NUMBER PROVIDED BY LAURA QUCIKLY FIND BOX INFO DSPSYSVAL QMODEL SHOWS BOX MODEL NUMBER IN THIS EXAMPLE E4C

23. TIP 9 FROM SPOOL TO EXCEL PROVIDED BY LAURA CREATE AN EXCEL FILE FROM A SPOOL FILE ACCOUNTING AND OTHER USERS LOVE THIS! USING NAVIGATOR BASIC OPERATIONS EITHER DRAG/DROP OR USE FILE EXPORT AND A TEXT FILE WILL BE CREATED

24. TIP 9 FROM SPOOL TO EXCEL PROVIDED BY LAURA CREATE AN EXCEL FILE FROM A SPOOL FILE ACCOUNTING AND OTHER USERS LOVE THIS! NEXT OPEN EXCEL FROM WITHIN EXCEL OPEN THE TEXT FILE CREATED

25. TIP 9 FROM SPOOL TO EXCEL PROVIDED BY LAURA CREATE AN EXCEL FILE FROM A SPOOL FILE ACCOUNTING AND OTHER USERS LOVE THIS! MANUEVER BACK AND FORTH UP AND DOWN UNTIL YOU RE CONTENT WITH COLUMS PRESS NEXT AND FINISH

26. TIP 9 FROM SPOOL TO EXCEL PROVIDED BY LAURA CREATE AN EXCEL FILE FROM A SPOOL FILE ACCOUNTING AND OTHER USERS LOVE THIS! FROM THIS SPOOL FILE TO THIS EXCEL FILE ONCE DONE IT CAN BE TREATED LIKE ANY OTHER EXCEL FILE

27. TIP 10 CONVERT A QUERY TO SQL PROVIDED BY LAURA CONVERT FROM QUERY400 TO SQL The RTVQMQRY command can be used extract the SQL statement from a Query. The statement is placed in a designated source file.

28. TIP 10 CONVERT A QUERY TO SQL PROVIDED BY LAURA CONVERT FROM QUERY400 TO SQL Creates SQL from Query

29. TIP 11 FINDING A COMMAND PROVIDED BY LAURA WHEN YOU CAN T REMEMBER THE COMMAND OR MENU SIMPLY PRESS F4 CHOOSE BY NAME OR VERB OR SUBJECT ETC .

30. TIP 12 TOP 5 DATABASE SECURITY TIPS WITH IBM CEO GINNI ROMETTY - THINK FORUM HTTPS://WWW.YOUTUBE.COM/WATCH?V=WM-CTUQP6HA

31. TIP 13 IBM I GEEK YOUTUBES CREATED BY IBMIGEEK.BLOGSPOT.COM HELPS MANAGE DISK UTILIZATION HTTPS://WWW.YOUTUBE.COM/CHANNEL/UC97MKUEDQ5A2K0OUG7EI9VG

32. TIP 14 IT - AS400 TUTORIALS AS400 TUTORIALS YOUTUBE HELPS MANAGE DISK UTILIZATION HTTPS://WWW.YOUTUBE.COM/PLAYLIST?LIST=PLAM_KQSET0UYKAIBAWMQ8H WRI4PIW6HLX

33. TIP 15 MISCELLANEOUS SITES HTTP://WWW.RPGPGM.COM/ HTTP://IPRODEVELOPER.COM/ HTTP://WWW.ITJUNGLE.COM/ HTTP://WWW-03.IBM.COM/SYSTEMS/POWER/SOFTWARE/I/INDEX.HTML HTTPS://WWW-947.IBM.COM/SUPPORT/ENTRY/PORTAL/SUPPORT HTTP://SEMIUG.ORG/LINKS.HTM HTTPS://WWW.IBM.COM/DEVELOPERWORKS/COMMUNITY/GROUPS/SERVICE/ HTML/COMMUNITYVIEW?COMMUNITYUUID=B542D3AC-0785-4B6F-8E53- F72051460822 HTTP://WWW.IBM.COM/SUPPORT/KNOWLEDGECENTER/SSW_IBM_I/WELCOME HTTP://MIDRANGE.COM/