Hi All,

I want to start a DB2 subsystem (v8 and v9) via JCL. For this, I currently have the following step to start the DB2 subsystem.

//DB2RSTRT EXEC PGM=IKJEFT01
//STEPLIB DD DISP=SHR,DSN=...
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DBxx)
-START DB2
END
/*


This works in case DB2 is already started (the log says that the subsystem is already running). But when the subsystem is stopped, it does not work, giving the following error message. It seems that DSN SYSTEM is used to connect to the DB2. That's why it is working if the subsystem is already running.

READY
DSN SYSTEM(DBxx)
DSNE100I DBxx NOT OPERATIONAL, RETRY COUNT IS ZERO
READY
-START DB2
IKJ56621I INVALID COMMAND NAME SYNTAX
READY
END


So how can I start a DB2 subsystem without using the DSN SYSTEM(...) command?

Regards

Hi

Yep, 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
you will need some program that allows you to issue such commands,
you can also write a rexx that issues commands to the console

I hope this should work.

//DB2START JOB MSGCLASS=A,CLASS=A
//*************************************************
//* *
//* START DB2 - JUST SUBMIT THIS JOB *
//* *
//*************************************************
//*
//*
//CMDS COMMAND '-DSN START
DB2'
//WAIT EXEC PGM=IEFBR14

Regards,
Roman G.

Hi momi,

thanks for your reply. I needed a bit to figure out how to issue operator commands from within JCL. START DB2 works fine now

Greetings