Need a ONLINE MAINFREAME Course/Poject Case Study) / Corporate Training/ application support ????

Lets schedule the class. Write me @ mfdtech@gmail.com, for more information refer to : http://onlinemainframe.blogspot.com/
Iam Willing to take up Freelancing projects on Cobol / MF. please mail me @ mfdtech@gmail.com

Google
 

Sunday, August 30, 2009

How to Solve SOC7 Abend - with screen shots


Below process helps to find out the statement, caused the SOC7 error.



Check the Sysout of RUNJCL. This shows the error statement and lists offset value

Take the Offset Value 000003C0

Got to respective Compilation Job listing, check the sysprint

Search for the offset value 0003C0 (delete +00 -- initial 3 letters of Offset value and search for it) check below 2 screen shots

This Offset value is listed under line no 0045 – which refers to Move statement.

Take this no. 045 and find for it in same sysprint. This points to the exact statement, caused SOC7

This 045 pints to the Move statement 1526, this is the exact line in the program

  • Check for the above line no. In source program. This points to the statement highlighted below.
  • Check the statement, variable check-4, which is added to check-6. These are having different Picture clause.
  • check-4 is alfhanumaric, holding some junk data, when this data is moved to Chcek-6 variable(of comp-3) creates SOC7 error.
  • This is just an example to explain one cause for Soc7 error and how to find the rootcause statement.

Method - 2 .

If abend-aid is available, check the same.

This will directly provides the error statement and line no.

Tuesday, May 5, 2009

steps in CICS-DB2 prog ins. screen shots

 



 




DB2-CICS Program Compilation and Execution  Process


 


1) Write a DB2/CICS program and compile it using DB2/CICS compailer JCL


2) Use BIND JCL for binding process


3) Now Sign on to CICS Region.


4) Define and install the Map .


5) Define and Install the Program.


6) Check whether there is any DB2 Connection. If not Create a connection using


ceda def db2c(....)


7) Define and install the DB2 Entry using


ceda def db2e(.......)


8) Define and install the DB2 Transation using


ceda def db2t(.......)


9) Define and install the Transation


10) now your setup is ready and you can run your program using the transation ID


























































Sample Screen shots – used for defining above process




4a. Define the map : MYMAPS







4b. Install map : MYMAPS











5a. Define the Program : PGM







5b. Install the Program : PGM











7b. Define the DB2ENTRY : VINAY









7b. INSTALL the DB2ENTRY : VINAY




















8.a. DEFINE the DB2ENTRY : HARI


















8.a. INSTALL the DB2ENTRY : VINAY












GROUP = VIJAY






9.a. DEFINE the transaction for the program(Pgm) : VBVB
















9.b. Install the transaction for the program(Pgm) : VBVB





























NOTE :




Before running this program check whether DB2 connection is defined using :


ceda def db2c(....) .. if no connection define it .








Monday, April 27, 2009

Why DB2 and why not VSAM (DB2 Vs VSAM)?

Why DB2 and why not VSAM (DB2 Vs VSAM)?



This is the common query raised by the programmers, whether to go with DB2/VSAM, hope below information helps.


VSAM

DB2

Definition

Database with file Concepts

Database built on File management storage system-DBMS concepts




Security levels

Provides at Dataset level only

Provides Good security levels at various levels (like table, table space etc.,)




Data Maintenance

It’s difficult compared to DB2.

Data retrieval or insertion or updates etc, is a bit difficult (puts more burden on programmer to achieve this).

Simply speaking Query interface is not supported

It’s easy to maintain data by using SQL

Data retrieval or insertion or updates etc, is far easier using SQl .

Query interface is supported




Referential Integrity

Again it programmers responsibility to design it accordingly

It’s one of the feature of DB2




Recovery

Recoverable only from Backup file

Auto recovery is not possible

Recoverable from DB2 log/ Backup

Auto recovery is possible




Backup

Incremental backup is not supported.

Incremental backup is supported




Performance

Performance is better than DB2, when small amount of data is used by the transaction

DB2 has good performance over VSAM, when high volume of data is used by the transactions




Accessible

Mainframes only

Can be shared with Distributed systems

Monday, March 16, 2009

DB2-CICS Program Compilation and Run Process

  • Write a DB2/CICS program
  • Compile it using DB2/CICS compailer JCL
  • Use BIND JCL for binding process
  • Now Sign on to CICS Region.
  • Define and install the program.
  • Define and install the Transation.
  • Check whether there is any DB2 Connection. If not Create a connection using ceda def db2c(....)
  • Define and install the DB2 Entry using ceda def db2e(.......)
  • Define and install the DB2 Transation using ceda def db2t(.......)
  • now your setup is ready and you can run your program using the transation ID