Mainframe, MVS and zOS Discussion

Interviewer asked a question that in a DB2/COBOL program, we want to update a table and we missed to code COMMIT in the program. Will the table gets updated when the program executes successfully? Though I answered that when program executes successfully then COMMIT will happen on its own. Hence the...

Thanks Robert. I think I'm already facing that situation... any comments on that, please.

We got another abend for the same job today again and the file has got 3 Million records! For these many records I need

Since the volume of records I have is 3,000,000, cylinders= int(3,000,000/180 = 16666.66) = rounded to 16,666

Is this really true???

Yes.. beware .

As far as I recall the trace had not had details about zIIP but I was told (later) that shop is zIIP enabled though it had details about the CPU number...that's why I ask here.

Thanks. But the confusion still persists. As I showed in my first post the SPACE in use in production Job is SPACE=(4068,(500,500),RLSE) and it works well most of the time. But recently we got SB37 because the file got 300K records compared to usual 50K. I'm not sure if I code SPACE=(CYL,(600,100),R...

Thanks Robert.

I was expecting TSO ISPVCALL to help a bit. You think this can not be used for this purpose?

I don't have access to issue console commands. But if I had, where do I issue them as am an application developer I'm just not sure.

Based on the inputs from you nic and with some reading, I do it this way: on 3390-n device forhalf trac blocking, I can have 55,996/2=27,998 blocksize. To calculate the most efficient blocksize to used: bestblocksize = INTEGER(half-track-blocksize/LRECL)*LRECL In my case the lrecl is 4068, so the be...

Thanks for the welcome Anuj.

As much I search for this I could only find some references like in DB2 10 - 'this' will be offladed to zIIP/zAAP etc. but I don't get a reference for the original questions, can someome please help.

That is also fine. 'views' could have been better but you rule that out already.

Check out some of the advertising blunders committed by some leading global brands: A hair products company, Clairol, introduced the "Mist Stick", a curling iron, into Germany only to find out that mist is a slang for manure. Not too many people want to use manure stick. When Gerber starte...

You can call it IP(s) or visitor(s)?

4068 is LRECL but even if it by chance same as LRECL and coded this way, system will treat it as BLKSIZE and not LRECL, right?? We have a dataclass coded for this sortout so will NOT that take care about the space thing itself? For example, if this data set has 1,000,000 records - what is the best S...

Thanks for the welcome Anuj.

Hi, For a sortout dataset, defined as below, we are constantly getting the SB37: //STEP01.SORTOUT DD DSN=xxxx.abcd.CBB.SORTOUT(+1), // DISP=(,CATLG,DELETE), // DATACLAS=xxxx, // SPACE=(4068,(500,500),RLSE), // VOL=(,,,6) The DSLIST information for this from a test job is this: General Data Current A...

Hi,

If a shop is zIIP and zAAP enabled, how can we identify this unless someone tells us this? Is there a way to see such a configuration?

And in general is there a way to see the configuration of the mainframes/LPAR in general?

Hi,

I'm Rahmat Ali. I've experience with COBOL, JCL, DB2 and VSAM. Though I don't consider an expert in all these but I'm good enough.

I''m from India too.

Found you on google while searching for File-aid related problem.