IBM Support

IZ28997: DB2BACKUP API ALLOW TO USE THE EXISTING DATABASE CONNECTION, WITHOUT DROPPING IT. THIS IS NOT WORKING WITH LOOPACK DB

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When a database is catalogued via loopback, using admin_cmd on
    an existing and open connection to run a backup, returns
    SQL30082N and RC3 (password missing).
    
    According Line item LI3931 this should works without errors.
    
    
    
    Sample for repro:
    
    > db2sampl
    >db2 catalog tcpip node loopno remote loopback server db2c_DB2
    DB20000I  The CATALOG TCPIP NODE command completed successfully.
    DB21056W  Directory changes may not be effective until the
    directory cache is
    refreshed.
    
    >db2 catalog database sample as loop_sam at node loopno
    DB20000I  The CATALOG DATABASE command completed successfully.
    DB21056W  Directory changes may not be effective until the
    directory cache is
    refreshed.
    
    >db2 connect to loop_sam user d024110
    Enter current password for d024110:
    
       Database Connection Information
    
     Database server        = DB2/NT 9.1.4
     SQL authorization ID   = D024110
     Local database alias   = LOOP_SAM
    
    
    >db2 " CALL ADMIN_CMD ( 'backup database loop_sam online to NUL'
    ) "
    SQL30082N  Security processing failed with reason "3" ("PASSWORD
    MISSING").
    SQLSTATE=08001
    
    The backup command now fails and asks for a user/password
    although a database connection exists.
    This should not occur. The stored procedure should use the
    existing database connection.
    

Local fix

  • N/A
    

Problem summary

  • When a database is catalogued via loopback, using admin_cmd on
    an existing and open connection to run a backup, returns
    SQL30082N and RC3 (password missing).
    

Problem conclusion

  • First fixed in V9.1 FP7
    

Temporary fix

  • N/A
    

Comments

APAR Information

  • APAR number

    IZ28997

  • Reported component name

    DB2 UDB ESE SOL

  • Reported component ID

    5765F4102

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-08-06

  • Closed date

    2009-06-05

  • Last modified date

    2009-06-05

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

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

    IZ38749

Fix information

  • Fixed component name

    DB2 UDB ESE SOL

  • Fixed component ID

    5765F4102

Applicable component levels

  • R910 PSN

       UP

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910"}]

Document Information

Modified date:
04 October 2021