mainframegurukul.com

Posted: **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.

Posted: **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?

Posted: **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.

Posted: **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. . .

Posted: **Mon Nov 28, 2011 2:19 pm**

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

Posted: **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

Posted: **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.

Posted: **Fri Dec 23, 2011 6:40 pm**

Glad you got it working and thanks for the follow up!