Skip to main content

DB2MOVE with -tn, -tf and load_only options returns error with sanity check failure and segmentation fault


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

db2move command syntax

Cross reference 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:

(0 users)Average rating

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.

Rate this page:


(0 users)Average rating

Add comments

Document information

DB2 for Linux, UNIX and Windows


Software version:
9.1, 9.5, 9.7


Operating system(s):
AIX, Linux, Solaris, Windows


Software edition:
Enterprise Server


Reference #:
1407144


Modified date:
2012-12-26

Translate my page

Content navigation