IBM Support

IT19341: AFTER INSTALLING DB2 11.1 DB2GREG -DUMP RETURNS UNDEFINED SYMBOL: OSSONETIMEONLYEX IN DB2 10.5

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If we install DB2 11.1 FP1 on a server where other previous DB2
    versions are still in use (10.5, 10.1) user in previous releases
    get error when running
    db2greg:
    
    User db2inst1 for DB2 10.5FC7 instance:
    
    db2inst1@morgoth ~ > db2greg -dump
    db2greg: symbol lookup error: db2greg: undefined symbol:
    ossOneTimeOnlyEx
    
    db2inst1@morgoth ~ > which db2greg
    /usr/local/bin/db2greg
    
    db2inst1@morgoth ~ > ls -l /usr/local/bin/db2greg
    lrwxrwxrwx. 1 root root 41 Jan 23 13:25 /usr/local/bin/db2greg
    -> /usr2/support/products/DB2111/bin/db2greg
    
    /usr2/support/products/DB2105FP7/bin > ./db2greg -dump
    S,GPFS,3.5.0.24,/usr/lpp/mmfs,DG_NOT_ALLOWED,DB2_INSTALLED,0,0,-
    ,1461659329,0
    S,DB2,10.5.0.7,/usr2/support/products/DB2105FP7,,,7,0,,146165939
    2,0
    V,DB2GPRF,DB2SYSTEM,morgoth.swglab.fr.ibm.com,/usr2/support/prod
    ucts/DB2105FP7,
    I,DB2,10.5.0.7,db2inst1,/usr2/db2inst1/sqllib,,1,0,/usr2/support
    /products/DB2105FP7,,
    V,DB2GPRF,DB2INSTDEF,db2inst1,/usr2/support/products/DB2105FP7,
    I,DB2,10.5.0.7,db2inst2,/usr2/db2inst2/sqllib,,1,0,/usr2/support
    /products/DB2105FP7,,
    I,DB2,10.5.0.7,olivierb,/usr2/olivierb/sqllib,,1,0,/usr2/support
    /products/DB2105FP7,,
    I,DB2,10.5.0.7,db2inst3,/usr2/db2inst3/sqllib,,1,0,/usr2/support
    /products/DB2105FP7,,
    I,DB2,10.5.0.7,db2hains,/usr2/db2hains/sqllib,,1,0,/usr2/support
    /products/DB2105FP7,,
    S,TSA,4.1.0.3,/opt/IBM/tsamp,DG_NOT_ALLOWED,DB2_INSTALLED,0,0,-,
    1485174240,0
    S,RSCT,3.1.5.12,/usr/sbin/rsct,DG_NOT_ALLOWED,DB2_INSTALLED,0,0,
    -,1485174240,0
    S,DB2,11.1.1.1,/usr2/support/products/DB2111,,,1,0,,1485174305,0
    V,DB2GPRF,DB2SYSTEM,morgoth.swglab.fr.ibm.com,/usr2/support/prod
    ucts/DB2111,
    I,DB2,11.1.1.1,db2inst4,/usr2/db2inst4/sqllib,,1,0,/usr2/support
    /products/DB2111,,
    V,DB2GPRF,DB2INSTDEF,db2inst4,/usr2/support/products/DB2111,
    
    user db2inst4 for DB2 11.1 instance:
    
    db2inst4@morgoth ~ > db2greg -dump
    S,GPFS,3.5.0.24,/usr/lpp/mmfs,DG_NOT_ALLOWED,DB2_INSTALLED,0,0,-
    ,1461659329,0
    S,DB2,10.5.0.7,/usr2/support/products/DB2105FP7,,,7,0,,146165939
    2,0
    V,DB2GPRF,DB2SYSTEM,morgoth.swglab.fr.ibm.com,/usr2/support/prod
    ucts/DB2105FP7,
    I,DB2,10.5.0.7,db2inst1,/usr2/db2inst1/sqllib,,1,0,/usr2/support
    /products/DB2105FP7,,
    V,DB2GPRF,DB2INSTDEF,db2inst1,/usr2/support/products/DB2105FP7,
    I,DB2,10.5.0.7,db2inst2,/usr2/db2inst2/sqllib,,1,0,/usr2/support
    /products/DB2105FP7,,
    I,DB2,10.5.0.7,olivierb,/usr2/olivierb/sqllib,,1,0,/usr2/support
    /products/DB2105FP7,,
    I,DB2,10.5.0.7,db2inst3,/usr2/db2inst3/sqllib,,1,0,/usr2/support
    /products/DB2105FP7,,
    I,DB2,10.5.0.7,db2hains,/usr2/db2hains/sqllib,,1,0,/usr2/support
    /products/DB2105FP7,,
    S,TSA,4.1.0.3,/opt/IBM/tsamp,DG_NOT_ALLOWED,DB2_INSTALLED,0,0,-,
    1485174240,0
    S,RSCT,3.1.5.12,/usr/sbin/rsct,DG_NOT_ALLOWED,DB2_INSTALLED,0,0,
    -,1485174240,0
    S,DB2,11.1.1.1,/usr2/support/products/DB2111,,,1,0,,1485174305,0
    V,DB2GPRF,DB2SYSTEM,morgoth.swglab.fr.ibm.com,/usr2/support/prod
    ucts/DB2111,
    I,DB2,11.1.1.1,db2inst4,/usr2/db2inst4/sqllib,,1,0,/usr2/support
    /products/DB2111,,
    V,DB2GPRF,DB2INSTDEF,db2inst4,/usr2/support/products/DB2111,
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 3 Fix Pack 3 or higher               *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 3 Fix Pack 3
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT19341

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-02-21

  • Closed date

    2018-03-19

  • Last modified date

    2018-03-19

  • 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

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
19 March 2018