PI74115: RATIONAL ASSET ANALYZER FOR SYSTEM Z 6.1.0.13 PTF

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• RATIONAL ASSET ANALYZER FOR SYSTEM Z 6.1.0.13 PTF
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Users                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: --- Issues addressed ---                *
  *                      o ESTABLISH PSB FOR RUN UNIT            *
  *                        POSTPROCESSING QUERY RETURNS          *
  *                        MULTIPLE ROWS WHEN ONLY 1 ROW WAS     *
  *                        EXPECTED - PI74124                    *
  *                      o RAA 6.1.0.11 CAN GENERATE MESSAGE     *
  *                        DMH1921E: SOURCE ANALYZER FAILED, NO  *
  *                        DATA COLLECTED FROM FILE - PI74726    *
  *                      o WSAA DB2 SUBSYSTEM TABLES ARE BEING   *
  *                        CREATED WITH THE QUALIFIER AS THE     *
  *                        TABLE NAME USING RAA 6.1.0.11 -       *
  *                        PI75088                               *
  *                      o AES1004E: Found unsupported syntax    *
  *                        VALUE on VALUES (NEXT VALUE FOR ...)  *
  *                        - PI75673                             *
  *                      o AES1004E: Found unsupported syntax    *
  *                        FETCH on DECLARE CURSOR ... FROM...   *
  *                        FOR clause - PI75858                  *
  *                      o LOGS FROM Z/OS ARE NOT LISTED IN      *
  *                        RAAZ IF WAS IS INSTALLED ON NON-Z/OS  *
  *                        PLATFORM - PI76692                    *
  *                      o SCANNING COBOL CODES FAILED WITH      *
  *                        "AES1004E FOUND UNSUPPORTED SYNTAX    *
  *                        AS/CORRELATION_NAME" ERROR - PI76787  *
  *                      o RAA: AES1004E: FOUND UNSUPPORTED      *
  *                        SYNTAX MATCHED - PI76788              *
  *                      o RAA: IGYGR1233: THE FIRST LITERAL     *
  *                        WAS GREATER THAN OR EQUAL TO THE      *
  *                        SECOND LITERAL IN THE THRU PHRASE OF  *
  *                        THE VALUE CLAUSE - PI76840            *
  *                      o RC=4 AES1019W MESSAGES FOR X-LENGTH   *
  *                        AND X-DATA ELEMENTS IN COBOL          *
  *                        PROGRAMS WITH LOB VARIABLES - PI76981 *
  *                      o RAA AND RAAZ SUPPORT FOR YEAR 2038    *
  *                        AND BEYOND - PI76986                  *
  *                      o ASSEMBLER LANGUAGE FILE MAY BE        *
  *                        CLASSIFIED AS COBOL IF CHARACTER IN   *
  *                        COLUMN 1 IS NON-ALPHABETIC - PI77210  *
  *                      o DMH5012E ON ERROR > PERFORM GROUP-BY  *
  *                        QUERY > SORT ON COUNT - PI77238       *
  *                      --- Inventory and analysis ---          *
  *                      o Introduced language-based SQL         *
  *                        concatenation sets for resolution of  *
  *                        EXEC SQL INCLUDE statements, such as  *
  *                        SQLCA and SQLDA.                      *
  *                      o Established the BATCHTSO control      *
  *                        file for handling custom entry point  *
  *                        names that will be processed as       *
  *                        synonyms for IBM's Batch TSO module   *
  *                        IKJEFT01.                             *
  *                      o Added COBOL 2002 to the language      *
  *                        level options for the COBOL           *
  *                        proprietary scanner.                  *
  *                      o Improved IMS DBD meta data for        *
  *                        capturing and sequencing the DATASET  *
  *                        macro DD names, data set groups and   *
  *                        DSGROUP parameters, and database      *
  *                        access types.                         *
  *                      o Expanded COBOL and PL/I meta data     *
  *                        for capturing the general             *
  *                        characteristics and editing           *
  *                        requirements of data elements, for    *
  *                        example, the COBOL PICTURE clause.    *
  *                      o Improved SQL column to table          *
  *                        resolution for multiple table         *
  *                        subselects.                           *
  *                      --- Impact analysis ---                 *
  *                      o The Literal details page, Data        *
  *                        elements tab, now provides selection  *
  *                        capability for impact analysis for    *
  *                        the 1 - n data elements that are      *
  *                        initialized by the literal.           *
  *                      --- Installation ---                    *
  *                      o Set up option JDBC host name was      *
  *                        lengthened, allowing the host name    *
  *                        field to wrap like the other host     *
  *                        name fields on the DMHINSTL panel.    *
  *                      --- Performance ---                     *
  *                      o Converted DMH_FILE_TO_CONT table to   *
  *                        a view.                               *
  *                      o Dropped unused column                 *
  *                        PROCESSING_TYPE_CD from the           *
  *                        DMH_QUEUE_TYPE table.                 *
  *                      o Eliminated obsolete inventory         *
  *                        insert, update and delete triggers    *
  *                        for selected asset types.             *
  *                      --- User interface ---                  *
  *                      o Logging control parameters have been  *
  *                        established in the Common.cfg file.   *
  *                        The maximum number of logs in a       *
  *                        sequence and the maximum file size    *
  *                        for a log can now be customized via   *
  *                        the logCount and logLimit             *
  *                        parameters, allowing more or less     *
  *                        logging to be visible to              *
  *                        administrative users on the Database  *
  *                        > Logs page.                          *
  *                      o Database > Execute a query page is    *
  *                        more forgiving of certain syntax,     *
  *                        such as SQL  comment lines, trailing  *
  *                        semicolons, and WITH UR (uncommitted  *
  *                        read) clauses.                        *
  *                      o Default columns on the Analysis       *
  *                        queue summary page have been          *
  *                        reordered for improved usability.     *
  *                      o Viewing source file restrictions      *
  *                        have been lifted in certain           *
  *                        scenarios, ensuring more files are    *
  *                        viewable. No view source option is    *
  *                        available for files of type archive,  *
  *                        class or binary, or if a file is      *
  *                        classified as empty or gone.          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  This APAR includes enhancements and fixes for all issues
  identified.
  

Problem conclusion

• Apply this APAR and follow all ++HOLD instructions to take
  advantage of the enhancements and fixes.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI45088

Modules/Macros

•    AESPANAL AESUTMSC AESUTMSE AESUTMSJ AESUTMSK
  BATCHTSO DMHACB   DMHCLDB  DMHCM    DMHCTDB  DMHDBDS  DMHDBRC
  DMHDIST  DMHE0011 DMHE0014 DMHE0017 DMHE0023 DMHE0024 DMHE0026
  DMHE0030 DMHE0039 DMHE0071 DMHE0072 DMHE0073 DMHE0074 DMHE0075
  DMHE0076 DMHE0077 DMHE0078 DMHE0079 DMHE0090 DMHE0094 DMHE0095
  DMHE0096 DMHE0097 DMHE0098 DMHE0100 DMHE0101 DMHE0103 DMHICFGU
  DMHITRG  DMHITRGD DMHIVIEW DMHI100  DMHI100H DMHI100P DMHI202
  DMHI203  DMHI204  DMHI205  DMHI207  DMHI400S DMHMBLST DMHMDA
  DMHMINTF DMHPSBS  DMHSCLM  DMHSSCAN DMHSTG1  DMHSTG2  DMHSVPPM
  DMHU200S DMHVERSN DMH0741  DMH4000  DMH5306  DMH5500  DMH630Z
  

Fix information

• Fixed component name

  RAA FOR SSTEM Z

• Fixed component ID

  5655W5700

Applicable component levels

• R610 PSY UI45088

     UP17/03/01 P F702

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.