Db2 LUW Administration Basic Commands

[@rajukr3263]

Excellent and Awesome info and explanation . Thanks for your great efforts and sharing with us 😍🤩🥰🙏🙏🙏🙌👍👏👏

[@DB2_Oracle]

Thank You for nice comment. Glad you liked it.

[@Local_Idiot12]

Its a great introduction to the Db2 commands!🙏

[@DB2_Oracle]

Thank you for nice comment.

[@jorgerine]

A good introduction and refresher to the Db2 commands.
A couple of points though: 1) you are using the instance owner account so people may not know how to set up their Db2 environment; 2) if there is more than one copy of Db2 installed, and there are different instances under each install, then you need to use db2ls first, followed by db2ilist from the appropriate path to show the instance under that install; 3) you use your own aliases/shortcuts, so it would be good to point these out.
Otherwise, thank you for the presentation. I was able to learn a thing or two.

[@DB2_Oracle]

Thanks for your time and detailed comment. I will surely take a note of it.

[@Mariyani]

Thanks for the video and also including a documents link with the detailed info in the PDFs.

[@asishmohanty4124]

IBM IBM IBM IBM IBM IBM IBM IBM DB2 integration migration deployment schedule IBM Cloud computing and AWS Amazon leadership ! Amazing! Thank you!

[@diegomatos2662]

That's a very good db2 commands workshop. Just a detail I would like to add: db2_ps command now display all db2 processes, including db2sysc

[@DB2_Oracle]

Thanks a lot. Perhaps for the next session.

[@rajscorpio18]

Nice explanation. Thanks for the video

[@International_Criminal_Court]

Great documentation, thanks a lot! 👏🏾✌🏾

[@hussamuddin-x8s]

Very helpful document. Thank you

[@ramlingpmanurkar]

Very useful video for beginners.

[@Tagore6308]

Thank you very much!! Good explanation.

[@Abdulhafeezkalsekar]

Thanks . Gr8 explanation

[@benoitd94]

very good , it should be great to have a tutorial on the management of space disk (datafiles, filesystem etc) for databases

[@DB2_Oracle]

Coming Up. This is long due.

[@raktimbhaduri6527]

Thanks a lot sir. A lot! Such a detailed video! Much appreciate it!❤️

[@improvespeechgiving9823]

Where should we run these commands ? SSH to the ip and SU in the CLI ? vs use Spufi or QMF ?

[@DB2_Oracle]

This is DB2 on linux so no SPUFI or QMF. You ssh to the ip and su to the instance owner and run these commands

[@MohsinKhan-pp7lw]

Thank you Thank you Thank you...

[@nikolo_tesla]

Thanks for the video!!!

[@ramadevi-et8kc]

Thank you Sir.

[@DB2_Oracle]

In this video, one of the subscriber pointed that I have stated 50003 as FIVE THOUSAND THREE and 50004 as FIVE THOUSAND FOUR. Apologies for this mistake. And thanks for pointing.

[@ronansaletti265]

Thanks a lot for the video.

[@SivaKumar-jh7nz]

Please do one more video on db2 certifications process ... if possible

[@pksinghbond]

Yes bro😂😂😂

[@kishorkhobre9834]

Thanks a lot for help

[@sivakumar-wb4pr]

Thanks for this video. Can you upload the videos for DB2 HADR setup and Purescale features.

[@DB2_Oracle]

Do you want HADR on PureScale? If that is the case, its difficult to set with the Laptop that I have. I need 2 clusters for that. I struggle with One Cluster alone with Memory and CPU. This is 10 years old laptop.

[@sivakumar-wb4pr]

@@DB2_Oracle If that the case , if we create the 2 instance on the same server then is it for possible for HADR setup simulation?

[@omsrisaikrishna9618]

What is difference between db2level and db2ls

[@DB2_Oracle]

db2level gives you the version/fixpack level of current instance/installation.
db2ls gives you list of all db2 installation.

[@omsrisaikrishna9618]

@@DB2_Oracle TQ so much sir
How could I contact you sir

[@lavanya996]

Thankyou

[@neerajkumarsingh4267]

If I type db2start how db2 will know which instance need to start like db2p Or db2c

[@DB2_Oracle]

It's mentioned in the video.
You need to use
export DB2INSTANCE=
And then you can verify using
db2 GET INSTANCE
On windows you will use set command instead of export
set DB2INSTANCE=

[@neerajkumarsingh4267]

@@DB2_Oracle Thank You Sir

[@sk.karimparveen118]

👍👍👍👍

[@Fridi-xk6xu]

can you pls share this document?

[@DB2_Oracle]

Document Link is added to the Video Description.

[@sibyjoshwa7758]

Can you please share the document?

[@DB2_Oracle]

Document Link is added to the Video Description.

[@rini_the_cat_lady]

Please share the document

[@DB2_Oracle]

Email ID?

[@rini_the_cat_lady]

@@DB2_Oracle [e-mail]

[@rini_the_cat_lady]

Kindly share the document🙏

[@srilekha1102]

Hi subodh , can u share the doc to [e-mail]

[@ak57401]

@@DB2_Oracle can you please share document [e-mail]

[@sriramsivaprasad]

Sir please provide total commands whatever u have ...

[@DB2_Oracle]

FIle containing commands is already uploaded and link shared in the description.

[@kishorkhobre9834]

Can you give command word file ?

[@DB2_Oracle]

Document is already shared. Link is in the description.