Bazi db2 komutlari

• db2stop: Stop database

• db2start: Start database

• db2text: start text services

• db2jstrt: start java listener

• db2level: Komut satirindan DB2 surumunu ogrenmek icin

• DB2 Log Files

  • /home/db2inst1/sqllib/db2dump/db2diag.log: for all DB2 errors/warnings

  • "jdbcerr.log" for errors/warning relating to Java JDBC connections

• db2 force application all : disconnect all users from database

• db2 list applications for db dbname: Information for each application that is connected to the specified database is to be displayed.

• The following example shows how to describe a table:

   db2 describe table user1.department

• To reset a registry variable for an instance back to the default found in the Global Profile Registry, use:

   db2set -r registry_variable_name 

• To delete a variable's value at a specified level, you can use the same command syntax to set the variable but specify nothing for the variable value. For example, to delete the variable's setting at the node level, enter:

   db2set registry_variable_name= -i instance_name      node_number