Technote (troubleshooting)
Problem(Abstract)
DB2MOVE with -tn, -tf and load_only options returns error with sanity check failure and segmentation fault.
Symptom
Command errors out with segmentation fault.
Cause
Tablenames with their schema qualifier were not listed in quotes.
Environment
Linux
Diagnosing the problem
DB2MOVE when used with the -tn or -tf and load_only options might encounter the following error as below:
-tf <filename> - File that has the tablename listed in it:
$ db2move sample copy -tf tablelist -co target_db test mode load_only schema_map "((vinny_95, db2inst1))" -u vinny_95 -p vinny_95
Application code page not determined, using ANSI codepage 1208
Line '' failed simple sanity check.
Either the line is empty, or the first character is not quote
Segmentation fault
-tn <tablenames>
$ db2move sample copy -tn vinny_95.employee -co target_db test mode load_only schema_map "((vinny_95,db2inst1))" -u vinny_95 -p vinny_95
Application code page not determined, using ANSI codepage 1208
Line 'VINNY_95.EMPLOYEE' failed simple sanity check.
Either the line is empty, or the first character is not quote
Segmentation fault
Please note that the above errors are seen only when db2move is used with the "load_only" clause. db2move would complete successfully if used with the default "ddl_and_load" mode.
Resolving the problem
The reason why the table name can not pass the sanity check is because the table names when using the "-tn" + LOAD ONLY should be listed with their schema qualifier in the format "schema"."table".
db2move command syntax:
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.db2.luw.admin.cmd.doc/doc/r0002079.html
So the command should look like:
$ db2move sample copy -tn '"vinny_95"."employee"' -co target_db test mode load_only schema_map "((vinny_95,db2inst1))" -u vinny_95 -p vinny_95
With the -tf option, also, the table name defined in the table_list file should also be listed with their schema qualifier in the format "schema"."table" as shown in the below example:
"vinny_95"."employee"
"vinny_95"."XXXXXXXX"
Also, ensure that there's no blank line in the file.
Related information
| Segment | Product | Component | Platform | Version | Edition |
|---|---|---|---|---|---|
| Information Management | Data Studio | AIX | 2.2.0.1 | IBM Data Studio Developer, IBM Data Studio Administrator |
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.