A Comprehensive Guide-And Index of  helpful web Pages
for the AS/400 professional; including DDS / RPGLE/SQL and XML/JAVA


Click The Map Link below to access the index to get started:

QAS400-Index.com 

Provides a Summary/Index of Links For AS400 professionals

 


Useful AS/400 Links that are not code related: 

 
RPG - Rational Cafe: 

https://www.ibm.com/developerworks/community/groups/service/html/communityview?communityUuid=b542d3ac-0785-4b6f-8e53-f72051460822

https://www.ibm.com/developerworks/community/forums/html/forum?id=11111111-0000-0000-0000-000000002284

http://www-01.ibm.com/software/rational/

_____________________________________________________________________________________



******************************************************************
Here is a List of PDF/Links for Utils & (for SOURCE CHANGE MGT.)
******************************************************************* 

------------------------------------------------------------
PDF - AS400-turnover_v100_developers_guide  (Click Link Below):   
------------------------------------------------------------

------------------------------------------------------------------
PDF - AS400-Aldon User Guides -  (Click Links Below)
--------------------------------------------------------------------
 Aldon - Primary site for IBM i - (V5R4, V6R1 or Higher)  
Click Link Below to go to Aldons Primary /Chg Mgt Site:  


------------------------------------------------------------------
MKS-Implementer - SCM for AS400 / iSeries: 
------------------------------------------------------------------


 

Other Misc Web sites that are not code related, but great for analyst:



Other Misc web sites for AS/400 Analysis:


Summary: Data-borough has been developing tools that capture and reuse the essence of complex code and applications written in AS400 RPG, COBOL, CA 2E (SYNON).  
------------------------------------------------------


Who Knew you could do that with RPG4 ? - (A Sorcerer guide)

- follow Link Here < RPG4 Sorcerers Guide >

-------------------------------------------------------------------------



PERFORMANCE TESTING/ENHANCEMENTS and Trouble shooting techniques IN V6R1 - And higher. PLEASE CLICK ON LINKS BELOW to use IBM tools for analyzing long running jobs:


Ever have a job that runs too long ??? (out of the blue)... and you need to know where the CPU cycles are being used, well just click the links below, to share data with IBM, and solve your issues: 

http://www-01.ibm.com/support/docview.wss?uid=nas8N1011896


Resolving the problem:


Job Watcher commands are native to the operating system starting at V6R1. Included in this document are instructions to collect Job Watcher data to aid in solving job or system-wide performance issues.

You should use the following instructions to collect one hour's worth of Job Watcher data:

Step 1. Verify the required Job Watcher PTFs are applied:

V6R1: http://www-01.ibm.com/support/docview.wss?uid=nas8N1013727

V7R1: http://www.ibm.com/support/docview.wss?uid=nas8N1012020

V7R2: http://www-01.ibm.com/support/docview.wss?uid=nas8N1020091

From an i5 operating system command line, type the following:

Note: An IBM Support Representative might change some of the parameters specified, based on a specific problem being reported.

Step 2. CRTLIB PMRxxxxx (where xxxxx = your PMR number)

Step 3. QSYS/ADDJWDFN DFN(QSLOW1) COLITV(5) ADDDTACGY((*CALLSTACK *ALWAYS) (*SQLCURSTMT *ALWAYS) ) WAITSTK((*CONFLICT 1) (*ABNWAIT 1) ) JOB((*ALL)) TASKNAME(*ALL) FRCRCD(*ITVEND) INCALLFST(*YES)

Step 4. SBMJOB CMD(STRJW DFN(QSLOW1) COL(RUN1) LIB(PMRxxxxx) ENDCOL((*NBRSEC 3600) (*DASDMB 4096))) JOB(JOBWATCHER) JOBQ(QSYS/QSYSNOMAX)

Note: If you would like to collect for a smaller amount of time, change the ENDCOL parameter in Step 4 to something less than 3600 seconds. If you would like to collect for more time, increase the ENDCOL parameter to a maximum of 7200 seconds. If more data is needed, wait for the batch job in Step 4 to complete and start another collection (per Step 4, issue another SBMJOB command and alter the COL parameter to say RUN2, for example).

Step 5. After the JOBWATCHER batch job ends, save the data.
CRTSAVF QGPL/JWSAVF
SAVLIB LIB(PMRXXXXX) DEV(*SAVF) SAVF(QGPL/JWSAVF) DTACPR(*MEDIUM)

Step 6. Send the data to IBM.

    • -Use e-mail if the file size is less than 20 MB



      If the data you will be submitting is less than 20 MBs and you would like to e-mail the data to IBM, you should use the following information. You may send e-mail to ibmi_support@ecurep.ibm.com using the instructions from the following URL: 


    • http://www-01.ibm.com/software/support/exchangeinfo.html#email



    • -Use the Service Request (SR) Tool if the file size 
    • is 2 GB or less



    -----------------------------------------------

    If you would like to analyze the data using the iDoctor GUI client interface you should visit:


    After registering for a 45-day Job Watcher Trial and reviewing the New User GUI Installation Requirements, you should click on the appropriate release of the operating system and download the Job Watcher Install Image.

    If you would like to setup a continuous Job Watcher collection consider using QMGTOOLS with this document -->   

    http://www-01.ibm.com/support/docview.wss?uid=nas8N1020478


    To learn more about Job Watcher, refer to the following URL:




    Other Performance Related Web Sites to Help you Analyze Long Running Jobs: (Using PEX Data)  


     As far as the PEX data goesIBM does not need you to collect this data for the entire run, but maybe 1 job that runs for 5 to 20 minutes.  And then possibly again for another 20 minutes later.  Below is a document that describes how to run tests (on jobs) using PEX data.  But remember, the more data you send IBM, the better !!!

    N1011762  Must Gather PEX data:  High CPU usage:
    http://www.ibm.com/support/docview.wss?uid=nas8N1011762

    ---------------------------------------------------------------------

                     -WHAT IS NEW IN IBM SQL/DB2 V7R2 - WHAT IS NEW - 


    New SQL Engine changes... (Added to 'Useful links'  and here, were added to:   QAS400-INDEX.COM


    And This One is a good one, because it stems out to all the details: Needed:

    https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20i%20Technology%20Updates/page/IBM%20i%207.2%20-%20Base%20Enhancements

     

    Another great IBM SQL web page for V7R2... strait on IBM's SITE:

    https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_72/rzahg/rzah8updates.htm



    Last Section:  looks really good for SQL performance ideas, and could help any team to brainstorm some ideas:

    https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_72/rzajq/whatsnew.htm



    Remainder of Sites Showing SQL Enhancements and Changes in V7R2:

    https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_72/rzajq/qryopt.htm

    https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_72/rzajq/rzajqidxadvorpred.htm

    https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_72/rzajq/rzajqidxadvorpred.htm

    https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_72/rzajq/idxadvisor.htm

    https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_72/rzajq/whatsnew.htm

    https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_72/rzahg/rzah8updates.htm

    ---

    https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_72/rzahg/rzahgicoverview.htm

    https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_72/db2/rbafzwhatsnew.htm

    https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_72/rzahg/rzahgicoverview.htm

    https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_72/sqlp/rbafywhatsnew.htm

    https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_72/rzaki/rzakiwhatsnew.htm