IBM Support

PI27095: RESULTS DATABASE FOR DB2 9.5 FAILS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • STEPS TO REPRODUCE:
    
    1. run ghtester_db2.sql against DB2 9.5
    
    
    EXPECTED RESULTS:
    
    Script executes correctly.  Results database is created
    
    ACTUAL RESULTS:
    
    CREATE TABLE "ACTION_EXECUTION" ( "ID" DECIMAL(19 , 0) GENERATED
    AS IDENTITY, "ACTION_ID" DECIMAL(19 , 0), "PARENT_ID" DECIMAL(19
    , 0), "EXPECTED" BLOB(2147483647) INLINE LENGTH 312 NOT LOGGED,
    "RECEIVED" BLOB(2147483647) INLINE LENGTH 312 NOT LOGGED,
    "CONSOLE" BLOB(2147483647) INLINE LENGTH 312 NOT LOGGED ) DATA
    CAPTURE NONE IN "TS32" DB21034E The command was processed as an
    SQL statement because it was not a valid Command Line Processor
    command. During SQL processing it returned: SQL0104N An
    unexpected token "INLINE LENGTH" was found following "19 , 0),
    "EXPECTED" ". Expected tokens may include: " ". SQLSTATE=42601
    
    WORKAROUND:
    
    None.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users of Rational Integration Tester using DB2 9.5       *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * The Rational Integration Tester database creation script     *
    * failed when used with DB2 version 9.5.                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • A new script, specific for DB2 9.5 has been created.  This
    script is named ghtester_db2_9.5.sql and is found in the scripts
    directory under the Rational Integration Tester installation
    directory, along with the other database scripts.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI27095

  • Reported component name

    RATL INTEGRA TE

  • Reported component ID

    5725G79IT

  • Reported release

    800

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-10-06

  • Closed date

    2015-04-12

  • Last modified date

    2015-04-12

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

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

Fix information

  • Fixed component name

    RATL INTEGRA TE

  • Fixed component ID

    5725G79IT

Applicable component levels

  • R860 PSY

       UP

  • R870 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSBLQQ","label":"Rational Test Workbench"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
17 October 2021