IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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 number

    LI74688

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-06-24

  • Closed date

    2009-10-14

  • Last modified date

    2009-10-14

  • 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

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 October 2021