Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Error in DB2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
casjar

New User


Joined: 11 Apr 2006
Posts: 2

PostPosted: Tue Apr 11, 2006 10:15 pm    Post subject: Error in DB2
Reply with quote

Hello,

I Have a Procedure for Deleting fields in several DB2 Tables, and im getting:

** FATAL DATABASE ERROR WAS ENCOUNTERED **
DB LAST STATUS = Q6

Does anyone know what this error can be ? This is a CoolGen Procedure.

Thank You

Casjar.
Back to top
View user's profile Send private message

martin9

Active User


Joined: 01 Mar 2006
Posts: 288
Location: Basel, Switzerland

PostPosted: Tue Apr 11, 2006 10:31 pm    Post subject:
Reply with quote

hy casjar,

pls provide how you are doing this...

martin9
Back to top
View user's profile Send private message
casjar

New User


Joined: 11 Apr 2006
Posts: 2

PostPosted: Tue Apr 11, 2006 10:56 pm    Post subject:
Reply with quote

Hi,

The Procedure is very long to post here, but here's an example:

"MOVE SPACES TO ERROR-ENCOUNTERED-SW OF GLOBDATA
CALL XXXXXX-ID USING IEF-RUNTIME-PARM1
IEF-RUNTIME-PARM2
GLOBDATA
IN-GRP-SVR-ER-SEL-0001RG IN-SVR-0006EV
IN-SVR-0007EV
OUT-AB-0001EV
END-CALL
IF STATUS-FLAG OF GLOBDATA NOT = SPACES OR
ERROR-ENCOUNTERED-SW OF GLOBDATA NOT = SPACES OR
VIEW-OVERFLOW-SW OF GLOBDATA NOT = SPACES
GOBACK
END-IF
MOVE '0088795244' TO CUR-AB-ID OF GLOBDATA
MOVE 'XXXXXX_ELIMINAR_ELEMENTOS_REDE' TO CUR-AB-NAME OF
GLOBDATA
COMPUTE LAST-STATEMENT-NUM = 0000000003
COMPUTE COD-ERRO-0008 = COD-ERRO-0001
MOVE STRING-A-0001XX TO STRING-A-0008XX
MOVE STRING-B-0001XX TO STRING-B-0008XX"

Im really trying to understand What "Last Status = Q6" means.

Regards

Casjar.
Back to top
View user's profile Send private message
martin9

Active User


Joined: 01 Mar 2006
Posts: 288
Location: Basel, Switzerland

PostPosted: Tue Apr 11, 2006 11:05 pm    Post subject:
Reply with quote

hy casjar,

i see you wrote a cobol program...
but to determine the error,
pls provide the jcl, joblog respectivley...
the messages you get as error message may be
self written, check your program for this string or check
all called programs, which include any sql query,
for this specific string...
maybe you also receive any sql code...?

martin9
Back to top
View user's profile Send private message
prakash271082

New User


Joined: 09 Sep 2005
Posts: 53

PostPosted: Wed Apr 12, 2006 10:44 am    Post subject: Re: Error in DB2
Reply with quote

Hi,
It might be that your Tablespace / Database might have gone to Check Pending State. In case check with your DB2 administrator.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts IDC2902I Error tzeche ABENDS & Debugging 2 Tue Mar 28, 2017 11:39 am
No new posts Need help with below DB2 error ashek15 DB2 3 Sat Mar 18, 2017 5:56 am
No new posts FINDREP Syntax Error seahawk789 DFSORT/ICETOOL 4 Thu Mar 09, 2017 10:11 pm
No new posts INVOKE WEBSERVICE error danik56 CICS 11 Thu Mar 09, 2017 11:52 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us