DBXX NOT OPERATIONAL, RETRY COUNT IS ZERO

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
archup20
Member
Posts: 31
Joined: Thu Dec 09, 2010 9:53 am

DBXX NOT OPERATIONAL, RETRY COUNT IS ZERO

Post by archup20 » Thu Nov 24, 2011 3:03 pm

Hi

While trying to load or unload a table, I am getting the retirn code MAXCC=12 and the error message as

DBXX NOT OPERATIONAL, RETRY COUNT IS ZERO

How can I solve this?
Please guide me.

I tried giving the command -START DB2, but that is not working.

Please help.

DikDude
Moderator
Posts: 1001
Joined: Fri Jul 22, 2011 8:39 am
Location: usa

Post by DikDude » Fri Nov 25, 2011 10:32 am

What was the response from the -start?

Issuing a command in n o way implies success.

How have you verified that dbxx is operational and the moment of failure?
Have a good one

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Fri Nov 25, 2011 12:56 pm

What is error-message ID, I'll guess it's - DSNE100I, yes?

Are you using IKJEFT01 to connect to DB2 or SPUFI or some third-party tool? Actually, if it's DSNE100I, in all the cases you need to issue operator command - start db2.

If db2 is not started, you can't use the DSN command processor. You will need your job to issue a operator command - start db2 or you will need some program that allows you to issue such commands, or you can also write a rexx that issues commands to the console. Ask some one at your shop - how do they do this.
Regards,
Anuj

DikDude
Moderator
Posts: 1001
Joined: Fri Jul 22, 2011 8:39 am
Location: usa

Post by DikDude » Sun Nov 27, 2011 2:45 pm

I tried giving the command -START DB2, but that is not working.
It appears that the -start was issued, but we have nothing to show that it was successful. . .
Have a good one

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Mon Nov 28, 2011 2:19 pm

DikDude, we've a very profounding reply "that is not working"! So...:D
Regards,
Anuj

hparthas
Member
Posts: 43
Joined: Thu Oct 21, 2010 11:17 pm

DBXX NOT OPERATIONAL, RETRY COUNT IS ZERO

Post by hparthas » Fri Dec 02, 2011 11:23 pm

Hi archup20,

Have you pointed the DB2 tables using Route card ? Have you checked whether the DBXX region which you are trying to read / update is available when you run the job. check master logs before you re-start the job.

Best Regards,
Harikrishnan

archup20
Member
Posts: 31
Joined: Thu Dec 09, 2010 9:53 am

Post by archup20 » Thu Dec 22, 2011 4:22 pm

Hi All,

I asked the DBA about this issue and got to know that the DBXX region was changed and we were not informed about it. So changing the DBXX region in the JCL, the load was successful.

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Fri Dec 23, 2011 6:40 pm

Glad you got it working and thanks for the follow up! :)
Regards,
Anuj

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others