I just come back to work in mainframe. I happy how detailed and accurated you explain. I miss my collegues from work 20 years ago. Everybody was like you...you explained why the FB 80 and then depending on DASD model. Awesome. Thanks a bunch
@@racingmars Completely agree. This is a great intro for people who are still new to mainframes and and I appreciate how you compare it to systems people are more familiar with (linux, "distributed", etc.). Looking forward to checking out some more of your videos.
Thank you for this! I'm actually working in QMF. I'm coming from MS SQL SERVER world so you can imagine my mind has been totally blown by the experience thus far... but this gave me some great background info I can leverage.
Having worked before with PostgreSQL and SQLite, and very occassionally MySQL... this interface to talk to the database is something completely different :) 20:49 - reminds me of times when I was a kid and wrote stuff in BASIC where there also were line numbers, typically 10, 20, 30 etc, and I could insert a command in between by adding line number like 35. It's really good that we're over these times ;)
Hi. Thx for video. Just one qestion. What about table space creation? Was table space created by default with the same name as table? As it should be one table per tablespace, am I right?
"On the multi-million dollar System Z mainframes that you can buy from IBM today." It would be nice, but my wife would not be amused to find a System Z mainframe humming away in the living room.
I lost where you had told me the name of the ISPF screen/profile that exposes the CICS and DB2 apps. when selecting ‘M’ for ‘More’. Please post again and thanks!
I and thank's very much for this video. I did not know ispf was the same than in z/OS. Many questions: 1/What is legal? I mean i do not have money to pay an IBM Machine. Just hercules emulation. I'm just learning Cobol an JCL , and may-be re-learning REXX which i practiced a long time ago. May we even learn their language or must we pay for? Are there version of 0S390 in or similar in the public domain and which we can emulate with hercules? 2/What is the cobol version? 3/Do you have REXX on this machine? 4/ really ? it contains DB2? Not sure you'll be able to reply to all theses questions but any help would be apreciate. Thank's in advance.
I have a doubt if sortin file is in length of 95 and sortout file length in 80 and trying to copy only few fields within 80 length but getting abend u0016 ... In spool it shows the sortout file length is mismatch how could I solve this?
This is case sensitive so here you’re giving unknown spaces while creating table so just wanted to know while creating sql query should I ignore this rule ? And give as much space between variables as I like ? Or I can say editor don’t follow case sensitive rule ? Coz whatever we write in editor considered as custom script or code and no need to take care for spacing? And also wanted to know here you have 10 blacks so if I give so much space in editor this will increase the space complexity? Or not? Also If i give unknown space and somehow I give this much of space that reaches beyond 72 blocks then what will happen? Because here you have 80 blocks and between range 72-80 blocks are already reserved by line/punch card numbers so if My text goes beyond 72 blocks I think this will crash the file? Or ended up with data loss
Just awesome.... its history but every now and then someone with DB2 mainframe projects keep pop up in modern IT. These systems still survive without any modern patches or security fixes or updates.
If you have write access to the dataset, yes. If you don't, no. The security product (usually RACF) should be configured correctly in a production environment such that users only have read and/or write access to the datasets they are allowed to use.
I just come back to work in mainframe. I happy how detailed and accurated you explain. I miss my collegues from work 20 years ago. Everybody was like you...you explained why the FB 80 and then depending on DASD model. Awesome. Thanks a bunch
I am also back after 5 years! once T-rex T-rex forever hahaha
Please continue posting mainframe tutorials. It helps us alot
this vid should be titled the only mainframe db2 starter video you will ever need to watch
Very good and close to reality of my mainframe presentation!
Thank you Matthew!
Thank you for this informative video! I wish you would have published more videos on mainframe topics.
I ended up starting a different channel for the mainframe/computing videos: ruclips.net/user/MainframesMorewithMatthew
@@racingmars Completely agree. This is a great intro for people who are still new to mainframes and and I appreciate how you compare it to systems people are more familiar with (linux, "distributed", etc.). Looking forward to checking out some more of your videos.
Thanks for the brief presentation, really nice and complete! Happy 2021
Thank you for this! I'm actually working in QMF. I'm coming from MS SQL SERVER world so you can imagine my mind has been totally blown by the experience thus far... but this gave me some great background info I can leverage.
Many thanks. Every worked fine as you explained on my DB2v9 on zOS installation.
Well done! I’m going to try and replicate this environment. Still learning though ;-)
Having worked before with PostgreSQL and SQLite, and very occassionally MySQL... this interface to talk to the database is something completely different :)
20:49 - reminds me of times when I was a kid and wrote stuff in BASIC where there also were line numbers, typically 10, 20, 30 etc, and I could insert a command in between by adding line number like 35. It's really good that we're over these times ;)
Hi. Thx for video. Just one qestion. What about table space creation? Was table space created by default with the same name as table? As it should be one table per tablespace, am I right?
My TI Direta channel has some shorts about mainframes, ISPF, TSO, JCL COBOL, DB2 etc.
"On the multi-million dollar System Z mainframes that you can buy from IBM today." It would be nice, but my wife would not be amused to find a System Z mainframe humming away in the living room.
Of course not. It belongs in the basement storage. You run a network cable to the living room.
I lost where you had told me the name of the ISPF screen/profile that exposes the CICS and DB2 apps. when selecting ‘M’ for ‘More’. Please post again and thanks!
Very cool demo. Thanks!
Tqq.. So much.. Its very helpful for me✋
19:20 "Who needs Data Studio when you have this!!!" 3 LOL's and 2 OMG's...
Where did you find a Mainframe to practice on? Cool vid
I and thank's very much for this video.
I did not know ispf was the same than in z/OS.
Many questions:
1/What is legal? I mean i do not have money to pay an IBM Machine.
Just hercules emulation. I'm just learning Cobol an JCL , and may-be re-learning REXX which i practiced a long time ago.
May we even learn their language or must we pay for?
Are there version of 0S390 in or similar in the public domain and which we can emulate with hercules?
2/What is the cobol version?
3/Do you have REXX on this machine?
4/ really ? it contains DB2?
Not sure you'll be able to reply to all theses questions but any help would be apreciate.
Thank's in advance.
I have a doubt if sortin file is in length of 95 and sortout file length in 80 and trying to copy only few fields within 80 length but getting abend u0016 ... In spool it shows the sortout file length is mismatch how could I solve this?
Hi ,do anyone have idea how we can autiincrement alphanumeric string in DB2 SQL mainframes.help menout searching a lot
Grt explanation
This is case sensitive so here you’re giving unknown spaces while creating table so just wanted to know while creating sql query should I ignore this rule ? And give as much space between variables as I like ? Or I can say editor don’t follow case sensitive rule ? Coz whatever we write in editor considered as custom script or code and no need to take care for spacing? And also wanted to know here you have 10 blacks so if I give so much space in editor this will increase the space complexity? Or not? Also If i give unknown space and somehow I give this much of space that reaches beyond 72 blocks then what will happen? Because here you have 80 blocks and between range 72-80 blocks are already reserved by line/punch card numbers so if My text goes beyond 72 blocks I think this will crash the file? Or ended up with data loss
Hi Bro,
I need Mainframe software and user id and password where i can get please let me know
How can we find out wich db is connected, when ever create a table.
Just awesome.... its history but every now and then someone with DB2 mainframe projects keep pop up in modern IT. These systems still survive without any modern patches or security fixes or updates.
Can I expect more DB2 QUERIES or DB2 ABEND RESOLUTION ON PROD ..?
Are you using Hercules for the emulator?
Would it be easy to over write someone else's data set?
If you have write access to the dataset, yes. If you don't, no. The security product (usually RACF) should be configured correctly in a production environment such that users only have read and/or write access to the datasets they are allowed to use.
Can anyone please help me with inserting data from PDS to a DB2 table?
data example: Day/Month,Jan,Feb
1st,23.0,24.0
2nd,20.1,25.1
I do like this database. How to look for this one at?
Who the heck still is working on OS/390? It was discontinued in 2004.
z/OS is alive and well and hasn't changed much since 1970.
this tutorial is on which version of ibm db2?
DB2 v9. But let's be honest...this is IBM mainframe software we're talking about, it'll be pretty much exactly the same +/- 20 years or more :-)
@@racingmars How did you install Db2. I am ready to pay for a trial license. Is there an official place where I can get it for?
@@ashishbitm www.ibm.com/products/z-development-test-environment
Mainframe DB2 Tutorial - www.ibmmainframer.com/db2-tutorial
Why didn't you make many more on mainframe?
I started a whole new channel for mainframe-related content! ruclips.net/channel/UCFvM_17zCxRhXHIhOyg-N3Qvideos
is this running on Hercules or something else?
which emulator this is ?
I want main frame access
I want a Ferrari
@@peterposto8984 - Then learn COBOL and DB/2, you'll make a fortune and buy that Ferrari.
Hey do you still want access this is a video to have your own mainframe ruclips.net/video/QEu_2jcBbsc/видео.html