Thread: SC 6.1: Push files to DB2

So I tried pushing all files to DB2 from an OOB 6.1 and although everything seems to work after a restart of the server there were some errors in the logfile.

I use DB2 UDB Express Edition 8.2 and all is running on windows 2000 professional workstation.

First errors come in early stage where the process is checking which files to move.

Extract from the log

Code:

  2184 07/24/2005 18:33:28 Number of files to convert = 240 menucmdlist
  2184 07/24/2005 18:33:28 Number of files to convert = 241 menurevision
  2184 07/24/2005 18:33:28 Number of files to convert = 242 model
  2184 07/24/2005 18:33:28 Number of files to convert = 243 modelconfig
  2184 07/24/2005 18:33:28 Number of files to convert = 244 modelvendor
  2184 07/24/2005 18:33:28  format name = mvtest,field name = sysmodcount,field length = 1000 
  2184 07/24/2005 18:33:28  format name = mvtest,field name = sysmoduser,field length = 1000 
  2184 07/24/2005 18:33:28  format name = mvtest,field name = sysmodtime,field length = 1000 
  2184 07/24/2005 18:33:28 Number of files to convert = 245 msgclass
  2184 07/24/2005 18:33:28 Number of files to convert = 246 msgjcl
  2184 07/24/2005 18:33:28 Number of files to convert = 247 msglog
  2184 07/24/2005 18:33:28 Number of files to convert = 248 msgtext
  2184 07/24/2005 18:33:28 Number of files to convert = 249 msgtype
  2184 07/24/2005 18:33:28 Number of files to convert = 250 nameduser
  2184 07/24/2005 18:33:28 Number of files to convert = 251 netconattr

What does those messages regarding field length mean and what do I need to do to correct this?

Later in the log following errors occur:

Code:

  2184 07/24/2005 18:34:03 Initiating a Conversion of ScriptLibrary
  2184 07/24/2005 18:34:03 Mapping tables ScriptLibrary
  2184 07/24/2005 18:34:03 Creating SQL Tables for ScriptLibrary
  2184 07/24/2005 18:34:03 File Copy: About to copy 39 records from 'ScriptLibrary' to 'TEMPScriptLibrary'
  2184 07/24/2005 18:34:03 sqdb2cli: Length (108371) of data for field script exceeds max (32700), truncated
  2184 07/24/2005 18:34:03 Field( script ) of File TEMPScriptLibrary was truncated 
  2184 07/24/2005 18:34:03 dbInsert: An error occurred while attemping to add a record
  2184 07/24/2005 18:34:03 dbInsert: file:(TEMPScriptLibrary) key:(name=AmazonSearchService)
  2184 07/24/2005 18:34:04 sqdb2cli: Length (43803) of data for field script exceeds max (32700), truncated
  2184 07/24/2005 18:34:04 Field( script ) of File TEMPScriptLibrary was truncated 
  2184 07/24/2005 18:34:04 dbInsert: An error occurred while attemping to add a record
  2184 07/24/2005 18:34:04 dbInsert: file:(TEMPScriptLibrary) key:(name=DoNotCall)
  2184 07/24/2005 18:34:04 sqdb2cli: Length (38382) of data for field script exceeds max (32700), truncated
  2184 07/24/2005 18:34:04 Field( script ) of File TEMPScriptLibrary was truncated 
  2184 07/24/2005 18:34:04 dbInsert: An error occurred while attemping to add a record
  2184 07/24/2005 18:34:04 dbInsert: file:(TEMPScriptLibrary) key:(name=GlobalWeather)
  2184 07/24/2005 18:34:04 File Copy: Copying 39 records from ScriptLibrary.  Completed 10
  2184 07/24/2005 18:34:04 sqdb2cli: Length (69262) of data for field script exceeds max (32700), truncated
  2184 07/24/2005 18:34:04 Field( script ) of File TEMPScriptLibrary was truncated 
  2184 07/24/2005 18:34:04 dbInsert: An error occurred while attemping to add a record
  2184 07/24/2005 18:34:04 dbInsert: file:(TEMPScriptLibrary) key:(name=SOAP)
  2184 07/24/2005 18:34:04 sqdb2cli: Length (39049) of data for field script exceeds max (32700), truncated
  2184 07/24/2005 18:34:04 Field( script ) of File TEMPScriptLibrary was truncated 
  2184 07/24/2005 18:34:04 dbInsert: An error occurred while attemping to add a record
  2184 07/24/2005 18:34:04 dbInsert: file:(TEMPScriptLibrary) key:(name=TextToImage)
  2184 07/24/2005 18:34:04 sqdb2cli: Length (135032) of data for field script exceeds max (32700), truncated
  2184 07/24/2005 18:34:04 Field( script ) of File TEMPScriptLibrary was truncated 
  2184 07/24/2005 18:34:04 dbInsert: An error occurred while attemping to add a record
  2184 07/24/2005 18:34:04 dbInsert: file:(TEMPScriptLibrary) key:(name=XigniteCurrencies)
  2184 07/24/2005 18:34:04 File Copy: Copying 39 records from ScriptLibrary.  Completed 20
  2184 07/24/2005 18:34:04 File Copy: Copying 39 records from ScriptLibrary.  Completed 30
  2184 07/24/2005 18:34:04 File Copy: Successfully copied 33 records from 'ScriptLibrary' to 'TEMPScriptLibrary'; 6 records rejected
  2184 07/24/2005 18:34:04 $L.bad.recs= 6
  2184 07/24/2005 18:34:04 $L.convert.flg = true
  2184 07/24/2005 18:34:04 Errors converting data for the ScriptLibrary file. The old file has been renamed to P4ScriptLibrary
  2184 07/24/2005 18:34:04 $G.warn.poss.convert.errors = true
  2184 07/24/2005 18:34:04 Completed Conversion of ScriptLibrary

What do I need to correct in order for the ScriptLibrary to be push correctly?

More errors:

Code:

  2184 07/24/2005 18:42:34 _createMergeInfo: Failed to open unique file 'computerprintersuniq' for parent file 'computer'
  2184 07/24/2005 18:42:34 _createMergeInfo: Failed to open attribute file 'computerprintersattr' for parent file 'computer'
  2184 07/24/2005 18:42:34 _createMergeInfo: Failed to open unique file 'computervideouniq' for parent file 'computer'
  2184 07/24/2005 18:42:34 _createMergeInfo: Failed to open attribute file 'computervideoattr' for parent file 'computer'
  2184 07/24/2005 18:42:34 _createMergeInfo: Failed to open unique file 'computerprocessorsuniq' for parent file 'computer'
  2184 07/24/2005 18:42:34 _createMergeInfo: Failed to open attribute file 'computerprocessorsattr' for parent file 'computer'
  2184 07/24/2005 18:42:34 _createMergeInfo: Failed to open unique file 'computerconnectionsuniq' for parent file 'computer'
  2184 07/24/2005 18:42:34 _createMergeInfo: Failed to open attribute file 'computerconnectionsattr' for parent file 'computer'
  2184 07/24/2005 18:42:34 _createMergeInfo: Failed to open unique file 'computerportsuniq' for parent file 'computer'
  2184 07/24/2005 18:42:34 _createMergeInfo: Failed to open attribute file 'computerportsattr' for parent file 'computer'
  2184 07/24/2005 18:42:34 _createMergeInfo: Failed to open unique file 'computerdriversuniq' for parent file 'computer'
  2184 07/24/2005 18:42:34 _createMergeInfo: Failed to open attribute file 'computerdriversattr' for parent file 'computer'
  2184 07/24/2005 18:42:34 _createMergeInfo: Failed to open unique file 'computerpointingdevicesuniq' for parent file 'computer'
  2184 07/24/2005 18:42:34 _createMergeInfo: Failed to open attribute file 'computerpointingdevicesattr' for parent file 'computer'
  2184 07/24/2005 18:42:34 _createMergeInfo: Failed to open unique file 'computerkeyboardsuniq' for parent file 'computer'
  2184 07/24/2005 18:42:34 _createMergeInfo: Failed to open attribute file 'computerkeyboardsattr' for parent file 'computer'
  2184 07/24/2005 18:42:34 _createMergeInfo: Failed to open unique file 'computerusbuniq' for parent file 'computer'
  2184 07/24/2005 18:42:34 _createMergeInfo: Failed to open attribute file 'computerusbattr' for parent file 'computer'
  2184 07/24/2005 18:42:34 _createMergeInfo: Failed to open unique file 'computerphysicaldrivesuniq' for parent file 'computer'
  2184 07/24/2005 18:42:34 _createMergeInfo: Failed to open attribute file 'computerphysicaldrivesattr' for parent file 'computer'
  2184 07/24/2005 18:42:34 _createMergeInfo: Failed to open attribute file 'computerlogicaldrivesattr' for parent file 'computer'

And more errors:

Code:

  2184 07/24/2005 18:50:17 Creating SQL Tables for inbox
  2184 07/24/2005 18:50:17 DB2 State: S0022  --- Native Error Value: -205
  2184 07/24/2005 18:50:17 DB2 Error Message: [IBM][CLI Driver][DB2/NT] SQL0205N  Column or attribute "RECORD_KEY" is not defined in "DB2ADMIN.INBOXA1".  SQLSTATE=42703


  2184 07/24/2005 18:50:17  sqlExec error: CREATE INDEX INBOXA1_P ON INBOXA1                     (RECORD_KEY,RECORD_NUMBER) 
  2184 07/24/2005 18:50:17  sqlExec error: sqlcode=-1

I will reports these findings to support too but wanted to check if anyone here know what to do about these errors as most of them seem to be related to parameters in the conversion itself rather than bugs in the conversion.

Problem was solved doing 2 things differently.

First off I changed pagesize in the tablspace from 4K to 32K.
Second I used db2ux instead of db2universal mapping.

Then everything was pushed to DB2 with no errors.

These are the commands I used to create a new bufferpool and tablespaces with pagesize of 32K

Code:

  create bufferpool bp32k size -1 pagesize 32K;
  create regular tablespace user32k pagesize 32K managed by system using ('user32k') bufferpool bp32k;
  create user temporary tablespace utemp32k pagesize 32K managed by system using ('utemp32k') bufferpool bp32k;