Troubleshoot and support > Migrate > Database tier migration issues
Troubleshoot: Massload error when using DB2
When using DB2 v9.5 Fix Pack 4 or Fix Pack 5, or DB2 v9.7 Fix Pack 1, if you perform an operation that uses the massload utility, such as the setdbtype command, the operation might fail.
Problem
An operation that uses the massload utility, such as the setdbtype command, fails with a crash in the Java process, due to a problem executing a DB2 API. You might see an error coming from the DB2 API in the error log for the related operation. The error will look something like this:
[Massload] -dbname malldev -dbuser db2inst1 -dbpwd ****** -infile /IBM/WCDE/xml/policies/xml/fixpack1/StoreReceipt.xml -method sqlimport -commitcount 1000 -maxerror 1 -customizer -schemaname DB2INST1 Unhandled exception Type=Segmentation error vmState=0x00000000 J9Generic_Signal_Number=00000004 ExceptionCode=c0000005 ExceptionAddress=41E0147E ContextFlags=0001003f Handler1=7FEE9F50 Handler2=7FEBAF90 InaccessibleAddress=0000012C EDI=4099AADC ESI=4099AB0C EAX=00000000 EBX=40D9E700 ECX=00000000 EDX=00000000 EIP=41E0147E ESP=4584FB20 EBP=4584FDE4 EFLAGS=00010246 GS=0000 FS=003B ES=0023 DS=0023 Module=c:\IBM\SQLLIB\bin\db2jcct2.dll Module_base_address=41E00000 Offset_in_DLL=0000147e Target=2_40_20090612_037149_lHdSMr (Windows XP 5.1 build 2600 Service Pack 3) CPU=x86 (1 logical CPUs) (0x7d77c000 RAM) ----------- Stack Backtrace ----------- Java_com_ibm_db2_jcc_uw_UWAdministrator_nativeGetCataloguedDatabases:0x41E0147E [0x41E011C6 +0x000002B8] 0x41CAFFA9 javaProtectedThreadProc:0x7FF1BFAD [0x7FF1BF30 +0x0000007D] javaThreadProc:0x7FF1C7D5 [0x7FF1C7A0 +0x00000035] GetModuleFileNameA:0x7C80B729 [0x7C80B56F +0x000001BA] ---------------------------------------
Solution
Refer to the following technote for more information: http://www-01.ibm.com/support/docview.wss?uid=swg21429314