LI74688: PROCEDURE SYSPROC.ADMIN_COPY_SCHEMA() FAILS TO COPY OBJECTS TO TARGET SCHEMA DUE TO SYNTAX ERRORS IN DDL GENERATED

DB2 Version 9.1 Fix Pack 8  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

APAR status

• Closed as program error.

Error description

• The procedure SYSPROC.ADMIN_COPY_SCHEMA() fails to copy the
  objects to the target schema specified as a parameters due to
  syntax errors in the SQL DDL statements generated.
  .
  The procedure completes fine with a successfull return code, but
  the execution of all the DDL SQL statements to create the new
  objects will fail with syntax error SQLCODE SQL0104N.
  .
  The syntax error is due to trailing characters at the end of an
  otherwise valid DDL statement.
  .
  This issue has mainly been seen on Linux environments.
  .
  /home/db2inst1> db2 "create table test.tab1(col1 int) in
  userspace1"
  DB20000I  The SQL command completed successfully.
  
  
  /home/db2inst1> db2 "insert into TEST.TAB1 values(1)"
  DB20000I  The SQL command completed successfully.
  
  /home/db2inst1> db2 "select * from TEST.TAB1"
  COL1
  -----------
          1
  1 record(s) selected.
  
  /home/db2inst1> db2 "CALL
  SYSPROC.ADMIN_COPY_SCHEMA('TEST','TEST1','COPY',NULL,'USERSPACE1
  ','USERSPACE1','ERRORSCH','ERRORTABLE')"
  
  Value of output parameters
  --------------------------
  Parameter Name  : ERRORTABSCHEMA
  Parameter Value : ERRORSCH
  
  Parameter Name  : ERRORTABNAME
  Parameter Value : ERRORTABLE
  
  Return Status = 0
  
  /home/db2inst1> db2 "select * from ERRORSCH.ERRORTABLE"
  TEST TAB1 TABLE -104 42601 2009-06-19-09.30.59.785034
  [IBM][CLI Driver][DB2/LINUXX8664] SQL0104N An unexpected token
  "6" was found
  following "IN "USERSPACE1"". Expected tokens may include:
  "END-OF-STATEMENT". SQLSTATE=42601
  CREATE TABLE "TEST1   "."TAB1" (
                  "COL1" INTEGER )
                 IN "USERSPACE1" 6
  1 record(s) selected.
  ,
  In the above example, notice the trailing "6" character. Various
  trailing characters have been seen such as "*","!",":"...
  

Local fix

Problem summary

• Users affected=All
  Problem Description= PROCEDURE SYSPROC.ADMIN_COPY_SCHEMA() FAILS
  TO COPY OBJECTS TO TARGET SCHEMA DUE TO SYNTAX ERRORS IN DDL
  GENERATED.
  

Problem conclusion

• Problem first fixed in V9.1 Fix Pack 8
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  LI74683

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  DB2 UDE ESE LIN

• Fixed component ID

  5765F4104

Applicable component levels

• R810 PSN

     UP

• R820 PSN

     UP

• R910 PSN

     UP

• R950 PSN

     UP