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.
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?
I'm not sure what the best practices are for tablespaces in DB2. You _could_ create a tablespace per table, but in other database systems I'm familiar with, that would probably be considered excessive if all those tablespaces are on the same underlying storage. You'd create different tablespaces if you needed different block sizes for some reason, if you wanted indexes on fast flash storage but the table data on regular disk storage, if you wanted some tables on one set of disks and other tables on other disks, etc. I'm _guessing_ the same kind of considerations makes sense for mainframe DB2, but I don't know.
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.
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!
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 ;)
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?
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.
"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.
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
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.
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.
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: th-cam.com/users/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.
Many thanks. Every worked fine as you explained on my DB2v9 on zOS installation.
Thanks for the brief presentation, really nice and complete! Happy 2021
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?
I'm not sure what the best practices are for tablespaces in DB2. You _could_ create a tablespace per table, but in other database systems I'm familiar with, that would probably be considered excessive if all those tablespaces are on the same underlying storage. You'd create different tablespaces if you needed different block sizes for some reason, if you wanted indexes on fast flash storage but the table data on regular disk storage, if you wanted some tables on one set of disks and other tables on other disks, etc. I'm _guessing_ the same kind of considerations makes sense for mainframe DB2, but I don't know.
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.
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!
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 ;)
My TI Direta channel has some shorts about mainframes, ISPF, TSO, JCL COBOL, DB2 etc.
Well done! I’m going to try and replicate this environment. Still learning though ;-)
Where did you find a Mainframe to practice on? Cool vid
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?
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.
Are you using Hercules for the emulator?
"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.
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
How can we find out wich db is connected, when ever create a table.
Very cool demo. Thanks!
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.
Hi Bro,
I need Mainframe software and user id and password where i can get please let me know
Can I expect more DB2 QUERIES or DB2 ABEND RESOLUTION ON PROD ..?
is this running on Hercules or something else?
Hi ,do anyone have idea how we can autiincrement alphanumeric string in DB2 SQL mainframes.help menout searching a lot
I do like this database. How to look for this one at?
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
Tqq.. So much.. Its very helpful for me✋
You say you're not an expert and you're just having fun believe me do you are an expert if I ever saw one
Why didn't you make many more on mainframe?
I started a whole new channel for mainframe-related content! th-cam.com/channels/FvM_17zCxRhXHIhOyg-N3Q.htmlvideos
which emulator this is ?
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.
Grt explanation
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
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.
Mainframe DB2 Tutorial - www.ibmmainframer.com/db2-tutorial
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 th-cam.com/video/QEu_2jcBbsc/w-d-xo.html
19:20 "Who needs Data Studio when you have this!!!" 3 LOL's and 2 OMG's...