Search

Sunday, September 30, 2012

JCL TO ALTER or DEFINE Queues


Code snippets for defining or altering Message Queues through JCL

Here I am changing INITQ for Local Queue PK01.

//PRODSTEP EXEC PGM=CSQUTIL,PARM='QueueManger Name'              
//SYSPRINT DD SYSOUT=*                                                 
//STEPLIB DD DSN=MQM.SCSQLOAD,DISP=SHR                                
//SYSIN DD *      

Saturday, September 29, 2012

MQ Batch Triggering Process


We can set up MQ job through MQ triggering Process. Job will be automatically triggered through MQ. Whenever the message is written to MQ the job mentioned will get triggered (G170G170). Here are the steps to be followed.

SET UP MQ Trigger batch job


DB2 Commands for Table Space

Access Commands


Steps to  go DB2 Commands panel:
     
    1. Go to DB2 DATA BASE INTERACTIVE FUNCTIONS MENU
    2. Go to DB2I PRIMARY OPTION
    3. Select MENU in the list (It is generally at position 1).