Hello members,

i am using DB2 10.5 on AIX (recently upgraded from v9.7) . i want to extract my backup policy XML file.

call sysproc.automaint_get_policyfile('AUTO_BACKUP','Au toBackup.xml')

but it is returning error:

SQL0443N Routine "SYSPROC.AUTOMAINT_GET_POLICYFILE" (specific name
"AUTOMAINT_GET_POLICYFILE") has returned an error SQLSTATE with diagnostic
text "". SQLSTATE=00000

DIAG MESSAGE as below:

2014-01-15-10.52.13.571723+330 I6524166A557 LEVEL: Warning
PID : 23789790 TID : 1029 PROC : db2fmp (C) 0
INSTANCE: instance1 NODE : 000 DB : MYDB
APPID : *LOCAL.instance1.140115014034
HOSTNAME: hodb1n
EDUID : 1029 EDUNAME: db2fmp (C) 0
FUNCTION: DB2 UDB, Policy, sqlpiAutomaintGetPolicySpCommon, probe:100
DATA #1 : <preformatted>
AutoMaintGetPolicy error, sqlcode is 0
sql error message is SQL10051

2014-01-15-10.52.13.572198+330 I6524724A468 LEVEL: Warning
PID : 23789790 TID : 1029 PROC : db2fmp (C) 0
INSTANCE: instance1 NODE : 000 DB : MYDB
APPID : *LOCAL.instance1.140115014034
HOSTNAME: hodb1n
EDUID : 1029 EDUNAME: db2fmp (C) 0
FUNCTION: DB2 UDB, Policy, db2AutomaintGetPolicyFileSpLocal, probe:90
DATA #1 : <preformatted>
Error returned from sqlpiAutomaintGetPolicySpCommon.

i corrected it by binding the schema,@db2ubind.lst and @db2cli.lst

db2 terminate
db2 CONNECT TO dbname user USERID using PASSWORD
db2 BIND /datahome/instance1/sqllib/bnd/db2schema.bnd BLOCKING ALL GRANT PUBLIC SQLERROR CONTINUE
db2 BIND /datahome/instance1/sqllib/bnd/@db2ubind.lst BLOCKING ALL GRANT PUBLIC ACTION ADD
db2 BIND /datahome/instance1/sqllib/bnd/@db2cli.lst BLOCKING ALL GRANT PUBLIC ACTION ADD
db2 terminate

after this my command "call sysproc.automaint_get_policyfile('AUTO_BACKUP','Au toBackup.xml')" run sucessfully with RC=0. But SURPRISINGLY NO AutoBackup.xml FILE was created.

Moreover after restarting instance. The same error as earlier start coming :
SQL0443N Routine "SYSPROC.AUTOMAINT_GET_POLICYFILE" (specific name
"AUTOMAINT_GET_POLICYFILE") has returned an error SQLSTATE with diagnostic
text "". SQLSTATE=00000

please suggest:

1. What to do for persistent binding effect ?
2. Why my file is not created ?

pls suggest.

thanks in advance

sumit