Db2 Tutorial: The Basics and Writing COBOL Programs (z/OS, OS/390, MVS/ESA)

[@joliettraveler]

This is amazing. I retired over 20 years ago. I used COBOL and DB/2.

[@HipolitoZamora-n2g]

Retired but want to work again in MF. Your tutorial bring back my past jobs. THANKS. Hope more to come from you.

[@jimsnellen6222]

Excellent work! I’m wanting to learn this stuff and your channel meets my needs perfectly.

[@hs-tc]

If you've got any suggestions, please do holler! I try to cover what people ask for, since I do love doing all of this for fun.

[@jimsnellen6222]

Well, since you asked! I’m working with COBOL as it relates to DB2. I’ve successfully created both batch and CICS programs with VSAM but now wanting to use DB2. I’m closely following this video! I haven’t got there yet but I’ll be probing IMS as well. Also, I’m really weak on TCP/IP. Anything you can come up with on IMS or TCP/IP would be fantastic!

[@hs-tc]

@@jimsnellen6222 I did a really bare-bones example in this vid of just that. IMS is something I haven't studied myself, but, it's totally different from any database style that exists nowadays. Makes sense considering it's from the 60s and they didn't really know what databases would be like, but, IMS is more like CICS than Db2 honestly. As for VSAM, I was going to make a VSAM tutorial but somehow stopped making it halfway through and never finished!

[@ricardoant.castromartinez5791]

Hi racingmars, your videos are very good, you learn quickly, thanks for the contributions. Do you have any video where you create a plan, table spaces

[@hs-tc]

Heh, I'm actually not racingmars -- that's the Mainframes And More channel! I do plan on that... I'm going to make a sequel to this video at some point, perhaps in a few weeks.

[@jay_wright_thats_right]

Old people in the comments reliving their glory days. I'm not mad at it.

[@678-b2n]

clear explaination thank you..

[@johnnydeguzman3562]

Anything about DB2 Thread?

[@jimsnellen6222]

Wow, you really know your stuff. I have both development OS’s for VSE/ESA and OS/390 and particularly interested in programming DB2 CICS applications. I am successful with batch programs but can’t get online programs to work. Could you do a video for VSE and perhaps another for MVS?

[@hs-tc]

This video should suffice for pretty much any MVS version... as for VSE, I need to figure out how to get Db2/VSE installed and running. It takes a crapton of impossible CICS junk to even start up. Db2/VM is another story... I've got one version of it running, but, I can't replicate it on any version! I think I may have a corrupted version of Db2/VM 6.1 or something... I'll keep trying, I semi-got SQL/DS to work, but, that's ancient compared to Db2/VM or Db2/VSE. Online programs are always a bit rough, especially on CICS... I think I made a VSE tutorial telling folks how to do CICS on VSE, though!

[@jimsnellen6222]

@@hs-tc This video works great for "batch" DB2 programs. Can you do a video with CICS accessing DB2? A simple display of any record in EMP will suffice. I'm looking at how to use the preprocessors for both CICS and DB2 to create a load module. It would be similar to "CICS COBOL Programming Tutorial: The Basics (MVS/ESA, OS/390, z/OS)" but with the DB2 element.

[@hs-tc]

@@jimsnellen6222 Actually, it's extremely easy! I never made a video on it, but, I did type up what to do... at least, I think I got it to work. I may have missed something, but, you basically do the exact same thing as both guides: DCLGEN, write your program, Db2 precompile, CICS precompile, COBOL compile, link-edit, bind, define to CICS, run. Here's my notes on it: hs.bam.moe/guides/mfguides/Db2_mvs_cics.txt (protip: please go up one directory level on that URL, I've got a wealth of information up there!).

[@jimsnellen6222]

@@hs-tc ok, finally got program to compile and execute in CICS. I'm getting SQLSTATE 51006 saying I need a connection. (??) I did DB2CONN, DB2ENTRY, DB2TRAN to no avail. I did DB2CONN=YES in SIT, still no change. Mods made to sample program to assist in debugging via CEDF. Apparently, I need more help. Protip was outstanding! Can we do email?

[@jimsnellen6222]

@@hs-tc I'm getting a connection error, SQLSTATE 51006. SPUFI works fine with MY_EMP. CEDF shows nothing for MYEMPRECORD. What am I doing wrong? Protip is outstanding!

[@antonioaniceto6598]

Thanks

[@TheRealNewBlackMusic]

Oh wow u remember os2 😊