Insight and perspectives

An instance can manage multiple databases.In an instance,each database has a unique name,its own set of catalog tables,configuration files,authorities & privileges.You can create multiple instances on Linux and Unix if db2 is installed as a root user.   To Create an Instance in DB2   ./db2icrt -u <fenceuserid> <instanceuserid>   To check the list of instances   Db2ilist   To get the current Instance   Db2 get instance   To Start & Stop the instance   Db2start   Db2stop

     SYNTAX                                                                             Description Db2Start To Start an Instance Db2Stop To Stop an Instance Db2 Connect to <DB> connect to database Db2Stop Force To stop the database manager instance forcefully Db2cc start the db2 control center Db2 List Db Directory To list all databases in an instance Db2 List Tables To list all tables in the connected Database Db2 List Applications List all Applications Connected Db2 ...