Topic
  • 1 reply
  • Latest Post - ‏2012-11-03T13:50:59Z by NMHV_Yuri_DoroZhko
NMHV_Yuri_DoroZhko
NMHV_Yuri_DoroZhko
5 Posts

Pinned topic Migration DB2 from z/OS to AIX by using IBM Data Movement Tool on AIX

‏2012-10-08T15:21:43Z |
Hi, I am using IBM Data Movement Tool to extract DDL script from DB2 for z/OS
IBM Data Movement Tool is installed on AIX. I implement the process migration using command line mode. When I am extracting DDL I got the message:
http://2012-10-08 14.37.00.800 Connection to remote zdb2 succeeded.
http://2012-10-08 14.37.00.808 Driver com.ibm.db2.jcc.DB2Driver loaded
http://2012-10-08 14.37.16.063 Database Product Name :DB2
http://2012-10-08 14.37.16.064 Database Product Version :DSN09015
http://2012-10-08 14.37.16.064 JDBC driver IBM DB2 JDBC Universal Driver Architecture Version = 3.57.82
http://2012-10-08 14.37.16.064 Database Major Version :9
http://2012-10-08 14.37.16.065 Database Minor Version :1
com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-471, SQLSTATE=55023, SQLERRMC=SYSIBM.SQLTABLES;00E7900C, DRIVER=3.57.82
at com.ibm.db2.jcc.am.bd.a(bd.java:679)
at com.ibm.db2.jcc.am.bd.a(bd.java:60)
at com.ibm.db2.jcc.am.bd.a(bd.java:127)
at com.ibm.db2.jcc.am.km.b(km.java:2164)
at com.ibm.db2.jcc.am.km.c(km.java:2147)
at com.ibm.db2.jcc.t4.db.k(db.java:354)
at com.ibm.db2.jcc.t4.db.e(db.java:96)
at com.ibm.db2.jcc.t4.t.e(t.java:81)
at com.ibm.db2.jcc.t4.sb.j(sb.java:160)
at com.ibm.db2.jcc.am.km.hb(km.java:2113)
at com.ibm.db2.jcc.am.lm.b(lm.java:3589)
at com.ibm.db2.jcc.am.mm.Vb(mm.java:144)
at com.ibm.db2.jcc.am.hc.a(hc.java:7737)
at com.ibm.db2.jcc.am.hc.Zd(hc.java:6355)
at com.ibm.db2.jcc.am.hc.getSchemas(hc.java:6283)
at ibm.IBMExtractUtilities.GetSchemaList(IBMExtractUtilities.java:2120)
at ibm.IBMExtractConfig.collectInput(IBMExtractConfig.java:3936)
at ibm.IBMExtractConfig.main(IBMExtractConfig.java:4307)
at ibm.RunTool.checkGUI(RunTool.java:25)
at ibm.RunTool.main(RunTool.java:83)
zdb2's schema List extracted=
Do you want to use 'szd08' as schema : 1
Or the extracted List : 2
Or your selected list : 3
Enter a number (Default=1) : 2
I consider I do not receive the extracted List because of this mistake. Naturally the migr directory is empty after execution of the the extracted list step. I can implement the extract DDL through IBM Rational Developer for z which are installed on Windows (my work station).
What can you advise me to resolve this problem?
Updated on 2012-11-03T13:50:59Z at 2012-11-03T13:50:59Z by NMHV_Yuri_DoroZhko
  • NMHV_Yuri_DoroZhko
    NMHV_Yuri_DoroZhko
    5 Posts

    Re: Migration DB2 from z/OS to AIX by using IBM Data Movement Tool on AIX

    ‏2012-11-03T13:50:59Z  
    I am glad to inform you that the problem was resolved by our administrators of z/OS. It was just necessary to activate one variable of WLM environment on z/OS.