Friday, November 16, 2012

67 Getting Start with DB2

Prepare the environment

IBM has provide the VM image  with DB2 9.7 Express-C preinstall on the Linux along with other training material. You can download them from here http://www14.software.ibm.com/webapp/download/search.jsp?pn=DB2+Express-C 

You will need to create the IBM account to download it. The account registration is free.   The DB2 Academic Training Materials has good instruction how to setup the VM. 

You will also need the VM Player to run the image.  I use VMware workstation long time ago ( about 5 years ) while the time VMware just announce the VM player product. As I recall, VM Player is the read-only VM solution which means it can not be used to create the virtual machine like VMware work station. I was quite surprise this time when I use the VM Player, I seem to be able to create the VM.  While starting up the VM, it will ask you whether to install or upgrade the VMware tools on the guest OS. This will help out the performance of the VM.

image

The Default user name is root. Password is password. You can find all those information in the VMware Basics and Introduction_Lab guide, which is also include in the training material.  After accept the license agreement, you will see the actual login screen

image

The user name is  db2inst1 and password is password .

Connect to the db2

db2list -all

List the basic db2 environment variables. Including the instance name.

Find the instance name from DB2INSTDEF

image

Attach to the instance. This step similar to the MSSQL/Sybase connect to the database instance but not yet to use the database.

db2 attach to  <INSTNACE NAME>

image

Find the DB2 database name from catalog.

db2 list database directory 

image

Connect to the database.

DB2 connect to <database name>

image

Run query from db2 command . DB2 table name is case sensitive.

DB2 "SQL Statement"

image

Other useful basic db2 command

Check memory/uptime from the snapshot

db2 get snapshot for dbm

image

check the instance configure

DB2 get dbm cfg
db2 get dbm cfg show detail

check the database configure 

db2 get db cfg
db2 get db cfg show detail

67 comments:

  1. Youtube
    www.youtube.com/watch?v=avgg8k5n83U
    Sign Up Here: viadmin.com/vmware-vsphere-training.html ...

    In this video, I am going to show you what are the options that you have when it comes to VMWare Training.


    There are five ways to get VMWare trained:


    What is fist Option that you have? It's a 5 day instructor-led VMWare training.


    Online classes are live, Instructor-Led training sessions, usually from 9 to 5 - delivered online. The course diration is Five days - 3 days of which are lectures and 2 days of instructor assisted hands-on lab, and at the end of the week extra days of self managed practice. And and extra week for VMWare Practice.

    Now... what is the soluton? You need VMWare Training that is more conducive to effective learning and covers more content than the official training offered by VMWare!

    We focus on making sure you have the skills critical to get the job you want and in the same time be capable of supporting critical cloud initiatives and datacenter infrastructure.


    Our teachers are highly qualified, each with years of experience. All hold VCP and CVIA certificates. More importantly, they love teaching VMWare online and strive to make your experience as fun, enjoyable and effective as possible.

    Instead of spending thousands of dollars for the official course you will be better of to Sign up for one of our online VMWare training classes and get top quality training for a fraction of the cost.

    Now, Option #2: You can use Personal, One on One VMWare Tutoring services, they are inexpensive and a great fit for busy professionals.


    Now let's take a look at what does the "One on One VMWare Training" session look like?


    Well, you pick up the topics and we deliver the training according to your schedule! You Have a personal VMWare Trainer which will instantly speed up your learning by responding to your individual training needs and questions.


    Sounds great - isn't it...? Today - You can learn VMWare online with the help of Skype and Team Viewer and enjoy high quality training given by our trusted and certified trainers - no matter where in the world you are.

    You need to get the training, but you have to work around busy work and family schedules. Not a problem! Our teachers are available 24 x 7, Monday to Friday and over the weekends! And because each class is only one hour or less, depending on your needs, you can choose to take class 2 or 3 times a week, without significant cost.


    Option #3 VMWare Practice Lab.


    Option #4: If you are preparing yourself for one of the VMWare Exams, and you are not sure what to expect at the exam, there is an Exam preparation training to get you ready for the exam.


    Option #5: Training videos. We created hundreds of videos that you can use to quickly learn and


    Now you can learn VMWare on your own terms, where you want and how you want.


    What I believe is...VMWare vSphere Training has to be affordable, practical and comprehensive. We offer just that with our set of VMWare Training sessions, practice lab and exam preparation.

    Our VMWare Training has been Specifically Designed to develop your VMWare Administrator qualities along with your ability to deal with real-life system problems.

    So don't wait for the last moment click on the link below and sign up for VMWare Training today!

    ReplyDelete
  2. Very interesting blog which helps me to get the in depth knowledge about the technology, Thanks for sharing such a nice blog..
    Java Project Center in Chennai | Java Project Center in Velachery | Java Projecs in Perungudi

    ReplyDelete
  3. This is the Nike Barcelona 2020 Windbreaker track jacket (kids').A really stylish look, cheap Soccer Jerseys the new Nike FC Barcelona 2020 windbreaker has a three-color block design - the top chevron is light brilliant yellow, cheap swansea city Jerseys combined with the club's famous Blaugrana colors.

    ReplyDelete
  4. I have read your blog. Your information is really useful for beginner. information provided here are unique and easy to understand. Thanks for this useful information. This is a great inspiring article. I am pretty much pleased with your good work.
    AWS Training Institute in Chennai | AWS Training Center in Velachery | AWS Certification Training in Velachery



    ReplyDelete
  5. Excellent post... Thank you for sharing such a informative and information blog with us.keep updating such a wonderful post..
    MicorSoft Azure Training Institute in Chennai | Azure Training Center in Chennai | Azure Certification Training in velachery | Online Azure training in Velachery

    ReplyDelete
  6. Extraordinary blog with amazing content.Thanks for posting such intersting post.keep sharing....
    Linux Training Institute in Chennai | Linux Training Center in Velachery

    ReplyDelete
  7. “Nice post!” Keep up the Amazing Good Work. Really your post was very interesting to read. Waiting for your upcoming update. Good Luck….

    Python Training Institute in Velachery | Python Training Institute in Chennai

    ReplyDelete
  8. http://www.chintansfamily.co.in/2016/06/yu-yunicorn-goes-official-with-mediatek.html?showComment=1619518497409#c5099930031966238052

    ReplyDelete
  9. Very Excellent and awesome Blog you are posted each and every Points are unique. Thanks for sharing such a nice Blog, keep on updating more
    Summer Courses Training in Tharamani|
    JAVA Training in Tharamani |
    Web Designing Training Center in Tharamani |
    Software Testing Training in Tharamani |
    Selenium Training in Tharamani |

    ReplyDelete
  10. The information you have here is really useful . It is truly supportive for us and I have accumulated some essential data from this blog.
    Web Designing Training Center in Chennai |
    Tally Training in Chennai |
    Selenium Training in Chennai |
    Summer Courses Training in Chennai|
    JAVA Training in Chennai |

    ReplyDelete
  11. Excellent Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging…
    Python Training in Chennai|
    Web Designing Training Center in Chennai |
    Tally Training in Chennai |
    AWS Training in Chennai|
    Hardware and Networking Training in Chennai |

    ReplyDelete
  12. Really you are done a wonderful job. I learn more knowledge while reading this blog Please keep on updating More ...
    PMP Exams in Velachery|
    PMP Exams in Chennai|
    PMP Exams in Tharamani|
    PMP Exams in Perungudi|
    PMP Exams in Thambaram

    ReplyDelete
  13. Nice post.. Its really an amazing with informative information and useful for everyone. Thanks for sharing your wonderful article..

    AWS Certification in Chennai | AWS Exam Center in Chennai | AWS Exams in Velacheri | AWS Online Exams in Velachery | Online Certification in Chennai

    ReplyDelete
  14. “Nice post!” Keep up the Amazing Good Work. Really your post was very interesting to read. Waiting for your upcoming update. Good Luck….



    AWS Training Institute in Velachery |
    AWS Training Institute in Chennai |
    AWS Training Institute in Tambaram |
    AWS Training Institute in Taramani|
    AWS Training Institute in Medavakkam

    ReplyDelete
  15. Nice blog. You put Good stuff. All the topics were explained briefly. So easily understand for me. I am waiting for your next awesome blog. Thanks for sharing.


    Python Training Institute in Velachery |
    Python Training Institute in Chennai |
    Python Training Institute in Tambaram |
    Python Training Institute in Taramani|
    Python Training Institute in Medavakkam

    ReplyDelete
  16. Amazing blog with informative information... Thanks a lot for sharing such an wonderful post with us...
    PCB Design Training in Chennai | PCB Training Institute in Velachery

    ReplyDelete
  17. Really amazing information you have shared with us. Thanks for sharing your wonderful post..
    ISTQB Certification in Chennai | ISTQB Exams in Velachery

    ReplyDelete
  18. Really it was an awesome article...very interesting to read. You have provided an nice article....Thanks for sharing..
    MBA Projects in Chennai | MBA Projects in Velachery

    ReplyDelete
  19. Really it was an awesome article...very interesting to read..You have provided an nice article....Thanks for sharing..
    PMP Certification in Chennai | PMP Exam Center in Velachery

    ReplyDelete
  20. Very informative blog. Thanks for sharing such a excellent blog. It is very useful for everyone. keep sharing
    GMAT Test Center in Chennai | GMAT Test Center in Velachery

    ReplyDelete
  21. Thank you so much for such valuable information sharing. It’s highly appreciated
    Agile Scrum Master Training in Chennai | Agile Scrum Master Training in Velachery

    ReplyDelete
  22. Wow!!!.. Superb blog with informative information's. Thanks for posting..
    TOEFL Test Center in Chennai | TOEFL Test Center in Velachery

    ReplyDelete
  23. Awesome post. Really you are shared very informative concept... Thank you for sharing. Keep on updating...
    GMAT Test Center in Chennai | GMAT Test Center in Velachery

    ReplyDelete
  24. Your article is really an informative content.. Its very useful to everyone.. keep updating
    Agile Scrum Master Training in Chennai | Agile Scrum Master Training in velachery

    ReplyDelete
  25. Thank you so much for sharing your nice post with us.. keep updating..
    GMAT Test Center in Chennai | GMAT Test Center in Velachery

    ReplyDelete

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates