After we moved our DB2 server from v9.7.3 x86_32 to v9.7.5 x86_64 (with server replacement) DB2 Storage Management has broken down. Tasks that make snapshots of tablespaces have stopped working with error:
CALL CAPTURE_STORAGEMGMT_INFO(2, ‘ ‘, ‘DATA_SPACE’)
SQL0443N Routine “SYSPROC.CAPTURE_STORAGEMGMT_INFO” (specific name “CAPT_STGMGMT_INF”) has returned an error SQLSTATE with diagnostic text “SQL0303”. SQLSTATE=38553SQL0303N A value cannot be assigned to a host variable in the SELECT, VALUES, or FETCH statement because the data types are not compatible.
Looks like data type incompatibility. I tried dropping all SGMT_* tables, recreate them using CREATE_STORAGEMGMT_TABLES and make a snapshot. Same error.
I’ve googled everything related to this in the Internet. There are only two topics without any suggestions here and here.
It seems like this problem has no solution (IBM DB2 bug?) and we should just go with it.
Tags: CAPTURE_STORAGEMGMT_INFO, CREATE_STORAGEMGMT_TABLES, DB2, IBM, snapshot, SQL0303N, SQL0443N, storage management
Niktips's Blog 
October 3, 2012 at 2:18 pm |
Hi, I had the exact same issue. Upping the stmtheap from 2048 to 4096 in the db cfg sorted it out. Got the idea from reading the diag log 😉