Fixes are available
DB2 Version 9.5 Fix Pack 3b for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3 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
On HP-UX Database Migration to V95 may fail with SQLB_AS_INVALID_STORAGE_PATH due to not being able to get complete file system information due to buffer overrun . Snippet of db2diag.log *********************** 2008-07-21-09.17.01.785694-240 I1837A651 LEVEL: Severe PID : 16529 TID : 1 PROC : db2agent (D02) 0 INSTANCE: db2d02 NODE : 000 APPHDL : 0-8 APPID: *LOCAL.db2d02.080721131701 AUTHID : DB2D02 FUNCTION: DB2 UDB, buffer pool services, sqlbGetFileSystemInfo, probe:15 MESSAGE : ZRC=0x800201A5=-2147352155=SQLB_AS_INVALID_STORAGE_PATH "Storage path does not exist or is inaccessible." DATA #1 : String, 30 bytes Could not get file system info DATA #2 : Pointer, 8 bytes 0xc00000001d710b40 DATA #3 : Pointer, 8 bytes 0x9fffffffffff0b00 DATA #4 : Bitmask, 4 bytes 0x00000180 2008-07-21-09.17.01.813628-240 I2489A529 LEVEL: Severe PID : 16529 TID : 1 PROC : db2agent (D02) 0 INSTANCE: db2d02 NODE : 000 APPHDL : 0-8 APPID: *LOCAL.db2d02.080721131701 AUTHID : DB2D02 FUNCTION: DB2 UDB, buffer pool services, sqlbCopyStoragePathsFromDiskCB, probe:20 MESSAGE : ZRC=0x800201A5=-2147352155=SQLB_AS_INVALID_STORAGE_PATH "Storage path does not exist or is inaccessible." DATA #1 : String, 29 bytes Error copying paths from disk
Local fix
For allocation of path buffers , db2 uses HPUX macro SYS_NMLN . By default , this macro has a value 9 , that means 8 characters plus null. So , the mount name and the path to the mount directory should be less or equal 8 . If you rename the directories to numbers, it might help. For instance , the path /0/1/2/ uses 7 characters .
Problem summary
ON HP-UX DATABASE MIGRATION TO V95 MAY FAIL WITH SQLB_AS_INVALID_STORAGE_PATH
Problem conclusion
First fixed in DB2 UDB Version 9.5, FixPak 3
Temporary fix
Comments
APAR Information
APAR number
IZ28164
Reported component name
DB2 UDB ESE HP-
Reported component ID
5765F4103
Reported release
950
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-07-24
Closed date
2009-04-19
Last modified date
2009-04-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 UDB ESE HP-
Fixed component ID
5765F4103
Applicable component levels
R950 PSY
UP
Document Information
Modified date:
03 October 2021