Mainframe Wednesday Talks#7 - DB2 Refresher in Just one Hour

Hello Everyone! here comes the another Mainframe Wednesday Talks on a Complete DB2 Refresher in just one Hour. I tried to cover all the topics of DB2 starting from
What is DB2 ,
Database ,
tables space ,
table ,
SQL Query's ,
QMF,
SPUFI,
Cobol DB2 Programming,
CURSOR life Cycle,
Sub Query,
Nested Sub Query's ,
Co related Sub Query,
Views,
UNION,
Primary Key,
Foreign Key,
Referential Integrity ,
DCLGEN ,
HOST VARIABLES,
SQLCA,
ERROR CODES,
and Many other topics..
#mainframe #mainframetutorial #mainframevideos #ibmdb2 #mainframes #mainframeclasses #mainframecourse #mainframerefresher #kumaritchannel #ibm #mainframeclassesonline #freemainframeclasses #mainframedb2refresher #mainframedb2 #db2refresher
Thank you! for watching. If you do like this Video, Please do share, comment and Subscribe for more regular updates..
#KUMARITCHANNEL

[@bhuvanabhuvi1699]

Hello sir, I have followed all your videos for my interview for jcl cobol and db2. And finaly I ve selected for first attempt. Thanks to you. I wil definitely recommend your channel for my friends. GREAT WORK 👏👏👏

[@KumarITChannel]

Keep it up!! and Congratulations Bhuvana bhuvi...

[@hemak8969]

@@kadamanchilavanya9547 How s your job in TCS andi

[@hemak8969]

@@kadamanchilavanya9547 How many years of experience you have in mainframes

[@RameshKumar-ng3nf]

People are so selfish. They write a comment. Then others asking help.. They dont respond at all. Then they say i was "BUSY". If you really wanted to help anyone there is no busy. Everybody is busy and if interested to help will help or multiple excuses.

[@carolyns1965]

I've just come back to COBOL/DB2 after a few years break and these are exactly what I needed to kickstart my old brain. Thanks so much

[@richardOutOfMatrix]

Thank you for this Video. I found it super helpful. I am a long timer on mainframes and was out of touch for few years and this really helped a lot.

[@pakoymm]

Thank you so much Kumar for share this helpful video with all the concepts of DB2 refresh, it help us to have the concepts fresh and understand better and be prepared for the interviews, thanks so much again.

[@luisaugusto4865]

...good..... From Salvador Brasil

[@manonmanik3178]

You got us.. We have been smashed with pre compilation that I was expecting in the whole video.. Nicely explained all the concepts.

[@motivationwithkailas]

You have covered almost everything in short time

[@sreevidya9247]

No words really quick refresher so useful thanks bro👍

[@KumarITChannel]

Welcome 👍

[@suzannesellers7383]

Excellent class! Will look at your other classes.

[@ksssrikanth]

Excellent refresher, Keep it up for thankless Job you have done.

[@KumarITChannel]

Thanks a lot

[@shirazbasha]

Thank you so much for listening to us and preparing the DB2 refresher........!!!!!!

[@KumarITChannel]

Any time!

[@mounikamona9274]

This is too Good👌

[@hemak8969]

Thank you so much , very nice refresher, quick n easy to understand

[@DoNaK_DeViL]

Very Useful 🎉

[@mubasheeruddiinkhaja7025]

Thanks Kumar

[@raghileshr1246]

Thank you so much.. It is very useful.. Please consider taking stored procedures

[@KumarITChannel]

Thank you! Raghilesh. Input taken.

[@sbiswas2798]

Very useful before the interview.

[@meenakshikumar5467]

Great work Sir

[@meenakshikumar5467]

Can you please make refresher for SQL

[@sutharsanamsaranathan1112]

Very Good. very useful

[@wesg01]

Awesome! Thank you

[@veminenivj4042]

Hi sir..can u plz make a series on IMS DB as well..plz..?

[@dharanipalanisamy9762]

Thanks for this refresher... it will be useful if you can make some videos on IMS DB/DC & CICS Thank you.

[@ravinderkaleru7097]

Great useful course .. thanks

[@sdharani532]

Awesome....Very useful👍

[@devotionallife2108]

Thanks

[@sarathpelluri9621]

thanks kumar.. it helped me a lot ..

[@kartik9525]

Thank you Sir..!!!

[@stephenit4772]

It's very helpful bro

[@reenadavid6497]

I think the query for selecting top nth salary is wrong. It should be A.EMPSAL

[@Khane_pe_Charcha]

Very helpful 👍

[@anuishwarya6601]

As ur explanation is easy to understand so kindly do videos on vision plus-cards and domain

[@robinmathew659]

It's really helpful 👍

[@anuishwarya6601]

Hello sir thanks for all ur videos kindly do videos on vision plus-cards and domain

[@mayurakshidey7787]

This is so good!!! How much you can cover in one hour!!

[@siddaboinasravanthi4771]

Very good learning refresher.. Thank you..sir but, sometimes we couldn't able to read letters in video, some sentences was not clear when u r explaining.please look into this...other than this everything looks good.

[@monisharaji5686]

Hi Kumar Sir ,Thanks for this video.And post a video on DB2 real time scenario questions

[@KumarITChannel]

Sure As soon as possible thanks!

[@raghavagarwal6545]

Thanks for this refresher... it will be useful if you can make some videos on some of the main MF tools, like Endeavor, File-Aid, Xpeditor, etc. Thank you.

[@KumarITChannel]

Great suggestion! Sure will work on it!! Thank you! Raghav for your input as always..

[@raghavagarwal6545]

@@KumarITChannel Ur welcome😊

[@LUXESTATEX]

@@KumarITChannel Are there videos on fileaid

[@stephenit4772]

Bro please upload most important and commonly asked interview questions for cobol, JCL,vsam, DB2 and cics in one video

[@nairshyama98]

Please add CICS refresher also ..

[@nareshvangari3815]

Good and quick refresher☺️ Would have been great if bind plan/package is covered

[@KumarITChannel]

Yes, you are right!! thanks! It's next in the queue..

[@poornimaganapathiraman5991]

Thanks a lot for this video, it is really helpful to prepare for interviews! I faced this question recently - why cursors get closed when commit is issued. Can anyone pls help clarify this

[@honeychoobies483]

We have to use WITH HOLD.. He has mentioned in the video

[@732mojo]

the ppt has wrong sql code when select query fetches more than one record.. its given as -81. where it is -811.

[@loveforcrickett]

I was gonna point out the same, I am surprised he just read the PPT with sqlcode -81 🤣🤣

[@ramivemi5985]

Can you please explain the major components and physical and logical objects in db2

[@007rockford]

Do you have the CICS course on UDEMY? the voice sounds very similar... ;)

[@KumarITChannel]

I do! . Good Catch

[@factnation1363]

Sir please add null indicator.

[@KumarITChannel]

Sure will do. Thanks

[@basicbadmintonusa]

How can I get access to a system like this? There are some Hercules mainframe and all but didn’t feel good.

[@CPR1922]

Hi Kumar How to contact you ,I have some doughts in mainframe errors or can you make more videos jcl abends and errors in COBOL plz

[@BobMossanen]

convert cobol to c# tool for db2 database connection

[@xypq8310]

Can I access both VSAM and DB2 from a cobol Cics program?

[@manishmisra78]

Pls upload the video on DB2 precompile and bind part

[@KumarITChannel]

Hello Manish, Please checkout the below video. kzbin.info/www/bejne/rKTGqaGhrbGonsk

[@priyaagarwal3104]

pls add restart logic

[@archiee_]

Hi can you please provide lectures pdf or drive link where can we get these lectures pdf COBOL db2 JCL pdf

[@732mojo]

the examples you showed for Joins is wrong.. we need to do it using alias.. please update.. if someone is not doing a cross check.. he is bound to fail if it comes in interview.. it can cost a job.. thanks for the video though..

[@shubhangijadhav8396]

Your video is useful but it need some correction

[@KumarITChannel]

Like what?

[@tanyabarnwal2061]

what is db2 stored procedure?

[@KumarITChannel]

A DB2 stored procedure is a precompiled program that is stored in a database and can be executed by calling it from other programs or applications. Stored procedures allow developers to encapsulate a set of SQL statements into a single, reusable program. This makes it easier to maintain and reuse complex business logic, and also helps to improve performance by reducing the amount of network traffic between the client and the database server

[@anushanag489]

Can you provide a quick refresher on SAS

[@KumarITChannel]

Thanks! for the inputs Anusha. I added the topic to my Queue,.

[@anilreddyadithya2788]

Bro.. can you please share the ppt doc

[@kalyankumarkanuturi1914]

how to create database and tabl space

[@KumarITChannel]

#1 CREATE DATABASE #2 CREATE TABLESPACE IN USING ( FILE '///file' 4K ) #3 COMMIT

[@motivationwithkailas]

This 2nd salary query do not look correctly. This needs distinct then count on salary

[@KumarITChannel]

Thanks! let me re-look on it. There are multiple ways of writing a query. Thanks for the input.

[@sumibharali4061]

I think I met u

[@Akshaytyagixin]

42:56

[@gatlavaishnavi3347]

can you share the pdf pls?