DAY 1 WITH DB2

First Day @ DB2

    As part of your work or if your company has newly migrated to DB2 from some other DB or If you want to start learning DB2 Installed it on your system and If this is your first day with DB2 LUW, actually there are few things you can do to become familiar with DB2.

1. Know your OS - Become familiar with your OS that DB2 is hosted on. If it is one of the UNIX/LINUX or AIX issue 'uname' (without quotes) or 'uname -a' to know the OS details.

**know if your company uses any jump server to connect to DB server. If so you can connect to jump server and then issue 

ssh <id>@<DB_server_ip>

2. Issue db2 command and see if you are navigated to CLP. In case if you are not and the system has thrown ksh error, try to hit db2profile file as shown below.

. /home/<inst_name>/sqllib/db2profile

issue db2ls or db2level to see the version details of DB2 DB installed in the system.

3. To see all the databases listed in the instance

db2 list db directory

4. To connect to a database

db2 connect to <dbname>

5. To see the database configuration parameters

db2 get db cfg

6. To see the database manager configuration parameters

db2 get dbm cfg

7. To update db/dbm parameters issue

db2 update db cfg for <db_name> using <parameter_name> <value>

db2 update dbm cfg for <db_name> using <parameter_name> <value>

8. Enter into /home/<inst_name>/sqllib file navigate  through various files, please do not change or edit any of the files. Look for db2dump for log files and backup folder for backup files.

Get feel of various tools that comes inbuilt with DB2 like db2pd, db2top, db2set and so on.

9. Key for good DB management is possessing enough knowledge on OS and good scripting knowledge.

I will come up with detailed architecture of DB2 and more detailed explanation for various DB parameters in coming days!!