OnDemand User Group

Support Forums => z/OS Server => Topic started by: niteskum on August 18, 2014, 01:20:13 AM

Title: Error when attempting ARSDOC cfsod_fed
Post by: niteskum on August 18, 2014, 01:20:13 AM

When I run the arsdoc cfsod_fed through BPXBATCH, getting below error when Document # (60000) is big, same job ran fine when document count was less (5000);

ARS0013E XXXXXXX DB Error: {DB2 FOR OS/390}{ODBC DRIVER}{DSN10015}  171
DSNT408I SQLCODE = -924, ERROR:  DB2 CONNECTION INTERNAL ERROR, 0001,   
0100,               00F30018   
                      DSNT418I SQLSTATE   = 58006 SQLSTATE RETURN     
CODE                                 DSNT415I SQLERRP    = DSNAET03   
SQL PROCEDURE DETECTING ERROR                      ERRLOC=1:13:2 --   
SQLSTATE=58006, SQLCODE=-924, File=arsseg.c, Line=6347 .

Please advice, if i am missing something or there is any limitation to # of Dcoument?                                                     

Title: Re: Error when attempting ARSDOC cfsod_fed
Post by: Greg Ira on August 18, 2014, 10:30:42 AM

Check your logs and see if something is cancelling your DB2 thread.  More than likely, because of the # of docs, you're hitting some max value and the thread is being terminated.

Title: Re: Error when attempting ARSDOC cfsod_fed
Post by: niteskum on August 19, 2014, 02:48:03 AM

Thanks. We are checking with DBA.