Mainframe, MVS and zOS Discussion

Hi All,

I have one quick question, I changed one COBOL IMS program to COBOL IMS DB2 program so do we need to recompile all the sub programs called by this main program even though sub program are non db2 programs.

TA

Hi,

How to fetch records which are starting with any digit and ending with any alphabets...in DB2
Please If any one can share the query.

Hi, What does a RESTART=* does in the Job card, can someone please help me on that? Is not it that it should be like RESTART=(*,CKPT), where CKPT is the check point. But with out a reference to a checkpoint, what does not mean? I looked at https://www.ibm.com/support/knowledgecenter/en/SSLTBW_2.1.0/...

Hi, In one of the SORT job we are making use of HIPRMAX=OPTIMAL. I have looked at about it here: HIPRMAX z/OS DFSORT Application Programming Guide SC23-6878-00 Blockset sorting performance can be improved by using Hiperspace along with disk for temporary storage. The HIPRMAX parameter sets the maxim...

Hello,

In our CICS system we ues VSAM files. These fiies are updated in batch, for this these files are closed to update and then again opened to be used in online system as database. Now i need to open and close these files, how shoud I do that? Can anybody guide me on this.

Thanks Robert and Anuj.

This answer helps, though, I'd wait for long reply too Anuj ..

Thank you Anuj. This is very to the point and crisp explanation and helps.

Regards,
E377878

Hi, There was this basic sounding question - but it makes me understand that it's tough to explain it in plain English to someone about how's IMS DB and DC works? I said that there is DBDs, PSBs and PCBs which connects all together to make the application work. The interviewer was convinced though I...

Hi,

In a recent interview I've been asked this - What is DB2 precompiler process and why we need it?

I got an answer like that to have the SQL part separate we'd need precompiler but I need to more about it. Can someone please explain.

Regards,