DSNTEP2 failed with -805.

Sabeer Meeran

DSNTEP2 failed with -805.
Hello,

We are experiencing a problem in the DSNTEP2 program failed with SQL Code
-805.. The detail error message is below :

READY
DSN SYSTEM(DB2C)
DSN
RUN PROGRAM(DSNTEP2) PLAN(DSNTEP2) LIB('SYS1.DSNDB2C.RUNLIB.LOAD')
DSN
END
RESULT OF SQL STATEMENT:
DSNT408I SQLCODE = -805, ERROR: DBRM OR PACKAGE NAME
[login to unmask email] NOT FOUND IN PLAN DSNTEP2. REASON
02
DSNT418I SQLSTATE = 51002 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXEPM SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -250 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFF06' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC
INFORMATION


The explanation of -805 is an application program attempted to use a DBRM
or package 'location-name.collection-id.dbrm-name.consistency-token' that
was not found.

Since it is related to program DSNTEP2, we are not sure what could be the
problem.. I attempted to restart the fialed program.It went fine !!

Can anyone please throw more light on this issue?



Thanks and Regards,



Sabeer M (Embedded image moved
IGA NL Account, to file: pic32673.jpg)
IBM India Ltd, Bangalore
Ph : 91-80-4154 3121
Mobile : 9845601383







---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Christopher Tee

Re: DSNTEP2 failed with -805.
(in response to Sabeer Meeran)
Sabeer

[login to unmask email] was rebound at 20:41 GMT last night due to a code refresh. In
future, you may want to raise this internally first, through a PR.

Chris Tee
DB2 Systems Programmer
Database Team
SSO IGA Technical Services
Internal Tel: 250072 External Tel: 023 9256 0072



Sabeer Meeran <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
30/11/2006 06:58
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc

Subject
[DB2-L] DSNTEP2 failed with -805.






Hello,

We are experiencing a problem in the DSNTEP2 program failed with SQL Code
-805.. The detail error message is below :

READY
DSN SYSTEM(DB2C)
DSN
RUN PROGRAM(DSNTEP2) PLAN(DSNTEP2) LIB('SYS1.DSNDB2C.RUNLIB.LOAD')
DSN
END
RESULT OF SQL STATEMENT:
DSNT408I SQLCODE = -805, ERROR: DBRM OR PACKAGE NAME
[login to unmask email] NOT FOUND IN PLAN DSNTEP2. REASON
02
DSNT418I SQLSTATE = 51002 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXEPM SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -250 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFF06' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC
INFORMATION


The explanation of -805 is an application program attempted to use a DBRM
or package 'location-name.collection-id.dbrm-name.consistency-token' that
was not found.

Since it is related to program DSNTEP2, we are not sure what could be the
problem.. I attempted to restart the fialed program.It went fine !!

Can anyone please throw more light on this issue?



Thanks and Regards,



Sabeer M (Embedded image moved
IGA NL Account, to file: pic32673.jpg)

IBM India Ltd, Bangalore
Ph : 91-80-4154 3121
Mobile : 9845601383







---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Raey

Re: DSNTEP2 failed with -805.
(in response to Christopher Tee)
To resolve the issue, you need to rebind EUHADB2A package

Christopher Tee <[login to unmask email]> wrote:
Sabeer

[login to unmask email] was rebound at 20:41 GMT last night due to a code refresh. In future, you may want to raise this internally first, through a PR.

Chris Tee
DB2 Systems Programmer
Database Team
SSO IGA Technical Services
Internal Tel: 250072 External Tel: 023 9256 0072


Sabeer Meeran <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]> 30/11/2006 06:58 Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email] cc
Subject
[DB2-L] DSNTEP2 failed with -805.




Hello,

We are experiencing a problem in the DSNTEP2 program failed with SQL Code
-805.. The detail error message is below :

READY
DSN SYSTEM(DB2C)
DSN
RUN PROGRAM(DSNTEP2) PLAN(DSNTEP2) LIB('SYS1.DSNDB2C.RUNLIB.LOAD')
DSN
END
RESULT OF SQL STATEMENT:
DSNT408I SQLCODE = -805, ERROR: DBRM OR PACKAGE NAME
[login to unmask email] NOT FOUND IN PLAN DSNTEP2. REASON
02
DSNT418I SQLSTATE = 51002 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXEPM SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -250 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFF06' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC
INFORMATION


The explanation of -805 is an application program attempted to use a DBRM
or package 'location-name.collection-id.dbrm-name.consistency-token' that
was not found.

Since it is related to program DSNTEP2, we are not sure what could be the
problem.. I attempted to restart the fialed program.It went fine !!

Can anyone please throw more light on this issue?



Thanks and Regards,



Sabeer M (Embedded image moved
IGA NL Account, to file: pic32673.jpg)
IBM India Ltd, Bangalore
Ph : 91-80-4154 3121
Mobile : 9845601383







---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm