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

Document information


More support for:

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

Machine Translation

Content navigation