I'm getting some error when I try to run db2look cmd with some options to generate ddl of my existing database. Actually, I have to move the database across different platform. So I need to generate the ddl for whole database & then run that script to create the new database.
this is the output i'm getting on running the cmd on db2cmd -
C:\>db2look -d TESTDB -i admin -w admin -e -o test_ddl.out
% USER is:
% Creating DDL for table(s)
% Output is sent to file: fos_ddl.out
SQL0444N Routine "SYSCAT.GETSEQPD" (specific name "SQL021031114520176"
is
implemented with code in library or path "\db2clifn", function
"CLI_udfGETSEQPD" which cannot be accessed. Reason code: "6". SQLSTATE=42724
Pls suggest me the solution asap.
this is the output i'm getting on running the cmd on db2cmd -
C:\>db2look -d TESTDB -i admin -w admin -e -o test_ddl.out
% USER is:
% Creating DDL for table(s)
% Output is sent to file: fos_ddl.out
SQL0444N Routine "SYSCAT.GETSEQPD" (specific name "SQL021031114520176"
isimplemented with code in library or path "\db2clifn", function
"CLI_udfGETSEQPD" which cannot be accessed. Reason code: "6". SQLSTATE=42724
Pls suggest me the solution asap.