CEDC Command to check MQconnection

CEDC Commands that can be used to check MQ connection 

If any user wants to know INITQ or any MQ manager or any other MQ parameter here is the command:

CEDC V MQ

It will give option as below. If you dont know give * for both the options and then press enter:

OBJECT CHARACTERISTICS
   CEDC View MQconn(         )
     MQconn         ==>       *
     Group            ==>       *

It will display all the MQConn for all the sysplex region as below.

ENTER COMMANDS
NAME            TYPE            GROUP                       LAST CHANGE 
MQ1A            MQCONN      CICSAB1             25/04/11   11:11:11
MQ1A             MQCONN     CICSAB2   v        25/04/11   11:11:11   
      
Give View in front of group you want to view as I gave above in red and press enter.

Introduction to most useful SYSIBM DB2 tables - PART 1

Here are most commonly used SYSIBM tables

SYSIBM.SYSTABLES : Any table or view or alias defined for your application will be present in this table with all the information.

Here I have got great links for tables where you can get details for each column of  SYSIBM tables. For each table there is separate link I have put them all together for quick reference.

http://supportline.microfocus.com/Documentation/books/sx51/rhsqst2l.htm

SYSIBM.SYSCOLUMNS: All the details about columns for any table along with characteristics of each column is defined here.

http://supportline.microfocus.com/Documentation/books/sx51/rhsqst0s.htm

Common CECI CICS commands used while debugging

CECI Commands that can be used to test or debug any CICS program

There are many commands in CICS which can be very handy when any developer wants to do unit testing.

CECI READ FIL(XYZ) RID(&A)

 Give F5 and define &A give length for that temporary character

When you give above command it will not read file until it is open. It will give errors as below: 

Triggering CICS transaction through batch - PART3

Common Error Messages - Batch Processing

Please refer PART1 and PART2 blog before going through this blog.

There are some common error messages that may be thrown when the transaction is launched using from the batch job.

1) When the CICS region is not active

IEE341I                       CICSREN1 NOT ACTIVE

2) When the console is not defined in the CICS Region

DFHAC2015 date time CICSREN1 Console consname has not been defined to CICS.

3) When the transaction does not exist in the CICS region

DFHAC2001 date time CICSREN1 Transaction 'tranid' is not recognized.

4) When the transaction is disabled in the CICS region

DFHAC2008 date time CICSREN1 Transaction tranid has been disabled and cannot be used.