Tag: IBM

Community

FIX: You receive an ‘Unexpected data length for the fixed-length column ‘[DB2OLEDB] .COLUMN” error message when you use the Host Integration Server 2000 DB2OLEDB driver

When you try to retrieve data by using the Microsoft Host Integration Server 2000 DB2OLEDB driver through a linked server from AS/400, you may receive an error that is similar to the following: Server: Msg 7347, Level 16, State 1, Line 2 OLE DB provider ‘DB2OLEDB’ returned an unexpected data len

Community

Asked & Answered

(Robert Catterall) What’s your recommendation for performing DB2 v.7 traces running under z/OS V1R4 in a production environment? Our tracing, implemented via zPARMs, consumes precious CPU cycles and real memory and also fills up the SYS1.MANx datasets with type 100-102 records in the SMF infrastruc