Mainframe DB2

Рет қаралды 63,137

Күн бұрын

Пікірлер: 61

@cristianedavanzo1842 3 жыл бұрын

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

@mondragonsi 2 жыл бұрын

I am also back after 5 years! once T-rex T-rex forever hahaha

@sanjayyyify 2 жыл бұрын

Please continue posting mainframe tutorials. It helps us alot

@rijuban4321 2 жыл бұрын

this vid should be titled the only mainframe db2 starter video you will ever need to watch

@higiniofuentes2551 4 жыл бұрын

Very good and close to reality of my mainframe presentation! Thank you Matthew!

@nicomulfetti8355 4 жыл бұрын

Thanks for the brief presentation, really nice and complete! Happy 2021

@MiguelRodriguezGonzalez-c9v Жыл бұрын

Thank you for this informative video! I wish you would have published more videos on mainframe topics.

@racingmars Жыл бұрын

I ended up starting a different channel for the mainframe/computing videos: kzbin.info

@monkeyseatcatfood Жыл бұрын

@@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.

@B-Luv 3 жыл бұрын

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.

@maus3454 3 жыл бұрын

Many thanks. Every worked fine as you explained on my DB2v9 on zOS installation.

@ricardoant.castromartinez5791 3 ай бұрын

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

@jimsnellen6222 2 жыл бұрын

Well done! I’m going to try and replicate this environment. Still learning though ;-)

@4wheelwarrior Күн бұрын

UNIX ... is actually so freakin user friendly compared to this! Wow. Very insightful vid, thanks.

@mieszkogulinski168 11 ай бұрын

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 ;)

@SamuelLuna-cl1cz Жыл бұрын

My TI Direta channel has some shorts about mainframes, ISPF, TSO, JCL COBOL, DB2 etc.

@jimsnellen6222 Жыл бұрын

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!

@diracflux 5 жыл бұрын

"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.

@HrHaakon Жыл бұрын

Of course not. It belongs in the basement storage. You run a network cable to the living room.

@tuzaguilar4201 2 жыл бұрын

Very cool demo. Thanks!

@jalandajames 3 жыл бұрын

Where did you find a Mainframe to practice on? Cool vid

@jeanyves5380 3 жыл бұрын

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.

@donndonn1358 4 жыл бұрын

Tqq.. So much.. Its very helpful for me✋

@dineshperumal1265 2 жыл бұрын

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?

@TheRealNewBlackMusic 4 ай бұрын

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

@cezarygolebiewski6736 5 ай бұрын

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?

@racingmars 4 ай бұрын

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.

@siddusmart9348 2 жыл бұрын

Grt explanation

@Createsofkaira19024 2 жыл бұрын

Hi ,do anyone have idea how we can autiincrement alphanumeric string in DB2 SQL mainframes.help menout searching a lot

@anuindrak 3 ай бұрын

Why I am getting DB2 errors while trying to insert data into a table?

@racingmars 3 ай бұрын

Do you think there is a single piece of information in your question that would allow *anyone* to provide any kind of meaningful answer?

@anuindrak 3 ай бұрын

You could ask me to provide more info so that can clarify my doubts instead of saying g in a rude way. Thanks for your time to put the comments@racingmars

@zuzububu 4 жыл бұрын

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

@johnrgrillot9901 Жыл бұрын

Are you using Hercules for the emulator?

@venkatpasumarthi2314 3 жыл бұрын

How can we find out wich db is connected, when ever create a table.

@Telugu_Fact_Videos 5 ай бұрын

Hi Bro, I need Mainframe software and user id and password where i can get please let me know

@Joe-iv5ks 8 ай бұрын

Would it be easy to over write someone else's data set?

@racingmars 8 ай бұрын

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.

@subramanyamreddypolamreddy2844 3 жыл бұрын

Can I expect more DB2 QUERIES or DB2 ABEND RESOLUTION ON PROD ..?

@jamesrakestraw7125 4 жыл бұрын

I do like this database. How to look for this one at?

@srinivasanpanneerselvam3643 4 жыл бұрын

Mainframe DB2 Tutorial - www.ibmmainframer.com/db2-tutorial

@velogoo 4 жыл бұрын

is this running on Hercules or something else?

@experiment8501 4 жыл бұрын

Why didn't you make many more on mainframe?

@racingmars 4 жыл бұрын

I started a whole new channel for mainframe-related content! kzbin.info/door/FvM_17zCxRhXHIhOyg-N3Qvideos

@shruti3117 4 жыл бұрын

this tutorial is on which version of ibm db2?

@racingmars 4 жыл бұрын

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 :-)

@ashishbitm 3 жыл бұрын

@@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?

@racingmars 3 жыл бұрын

@@ashishbitm www.ibm.com/products/z-development-test-environment

@michaeldickenson8880 3 жыл бұрын

Can anyone please help me with inserting data from PDS to a DB2 table?

@michaeldickenson8880 3 жыл бұрын

data example: Day/Month,Jan,Feb 1st,23.0,24.0 2nd,20.1,25.1

@sivabalarasup7556 3 жыл бұрын

which emulator this is ?

@nomadwcd8877 3 жыл бұрын

Who the heck still is working on OS/390? It was discontinued in 2004.

@DoesMamaKnow 3 жыл бұрын

z/OS is alive and well and hasn't changed much since 1970.

@ramanakvin 3 жыл бұрын

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.