IBM Support

IZ19633: ERROR 'OBJECT IS INOPERATIVE IN SOURCE SCHEMA; NOT COPIED' AFTER COPYING A SCHEMA USING DB2MOVE.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • While using db2move utility to copy a schema from one database
    to another database we get this message if the following steps
    are performed,
    
    db2 create db test
    db2 create db test1
    
    db2 connect to test
    db2 set current schema=ZAHN
    db2 "create table ZAHN.t5(c1 int)"
    db2 "create table ZAHN.t6(c1 int)"
    db2 "create view ZAHN.v1 (a,b) as select ZAHN.t5.c1 a,
    ZAHN.t6.c1 b from ZAHN.t5, ZAHN.t6"
    db2 drop table ZAHN.t6
    db2 create table ZAHN.t6(c1 int)
    
    db2move test copy -sn ZAHN -co target_db test1 -u administrator
    -p <"password">
    The output of the above command will be like,
    Application code page not determined, using ANSI codepage 1252
    *****  DB2MOVE  *****
    Action:  COPY
    Start time:  Mon Mar 03 16:46:50 2008
    All schema names matching:  ZAHN;
    Connecting to database TEST ... successful!  Server : DB2 Common
    Server V9.5.0
    Copy schema ZAHN to ZAHN on the target database TEST1
    Create DMT :  "SYSTOOLS"."DMT_47cbde28adca4"
    Start Load Phase :
    
    db2move finished successfully, however there are errors reported
    in the error file, COPYSCHEMA.20080303164650.ERR. Please refer
    to this file to correct any failures.
    
    If you open the error file COPYSCHEMA.20080303164650.ERR you
    will find the table T6 is not copied.
    1 Schema     : ZAHN.T6
      Type       : TABLE
      Error Msg  : Object is inoperative in source schema; not
                      copied
      DDL        : No DDL
    

Local fix

Problem summary

  • First fixed in DB2 UDB Version V9.1, FixPak 7
    

Problem conclusion

  • First fixed in DB2 UDB Version V9.1, FixPak 7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IZ19633

  • Reported component name

    DB2 UDB ESE HP-

  • Reported component ID

    5765F4103

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-04-09

  • Closed date

    2009-04-16

  • Last modified date

    2009-04-16

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

    IZ19616

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

Fix information

  • Fixed component name

    DB2 UDB ESE HP-

  • Fixed component ID

    5765F4103

Applicable component levels

  • R910 PSY

       UP

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

Document Information

Modified date:
16 April 2009