Fixes are available
DB2 Version 9.5 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
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.5 FP4
Temporary fix
N/A
Comments
APAR Information
APAR number
IZ38749
Reported component name
DB2 UDB ESE SOL
Reported component ID
5765F4102
Reported release
950
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-11-27
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:
Fix information
Fixed component name
DB2 UDB ESE SOL
Fixed component ID
5765F4102
Applicable component levels
R950 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":"950"}]
Document Information
Modified date:
03 October 2021