DB2 common administrative commands

2011-01-06  来源:本站原创  分类:Database  人气:76 

This article describes the management of common db2 commands can open the "command line processor" input to run, you can also "db2 control center" in the "Command Editor" graphical interface for managing input operation.
db2 sql management commands, including commands, system commands with db2 different.

DB2 common administrative commands

Instance level:

1) Start the database manager instance

db2start

2) Stop the database manager instance

db2stop

3) Get the database manager configuration settings

get dbm cfg

4) shows the current database manager parameter values and delay values

get dbm cfg show detail

5) returns the value of environment variables DB2INSTANCE

get instance

6) Disconnect all applications connected with the database

force application all

7) by using a password and user ID for the remote instance of the connection

attach to user using

Database level:

8) explicitly in connection with the database user and password

connect to [[user] using]

9) explicitly activate the database

activate database

10) The failure to explicitly make the database

deactivate database

11) Disconnect the connection with the current database

connect reset

12) shows the current value of database configuration parameters and delay values

get db cfg show detail

13) shows the database configuration settings database

get db cfg for

14), the database configuration parameter database

Updated value

update db cfg for using

15) lists the tables in the database

list tables [for {user | all | system | schema}] [show detail]

If you do not specify any parameters, the default is to list the current user's table.

16) displays a table or view column information

describe table

17) showed that the space logo, name, type, content and status

list tablespaces [show detail]

18) shows that the specified table space container information

list tablespace containers for [show detail]

相关文章
  • DB2 common administrative commands 2011-01-06

    This article describes the management of common db2 commands can open the "command line processor" input to run, you can also "db2 control center" in the "Command Editor" graphical interface for managing input operation. db2

  • DB2 common administration commands 2011-01-06

    This article describes the management of common db2 commands that can open the "command line processor" type run, you can also "db2 control center" in the "Command Editor" GUI management input to run. db2 sql management comma

  • DB2 common command order 2010-05-06

    DB2 common command order [2009-9-22 15:57:00 | By: huang1989] 0 Recommend the following documents as in Annex / / Remove table field (note 3 to this table for each delete the reorganization because the default to change the way three times, after re-

  • DB2 commonly used commands - Long time no see 2010-10-26

    Long time not get the database in this area, and today I encountered this problem for a friend, Ha ha! More classic Command line window # Open a command line window db2cmd # Open the Control Center db2cmd db2cc # Open a command editor db2cmd db2ce Op

  • Common SSH Commands Daquan [turn] 2010-12-10

    Common SSH Commands Daquan rm-rf mydir / * mydir directory to delete * / cd mydir / * mydir directory to enter * / cd - / * return the parent directory * / cd ~ / * return root * / mv tools tool / * the tools directory rename tool * / ln-s tool bac /

  • Use of common network commands (1) 2010-03-30

    Use of common network commands 1, Ping command (1) Ping the help of view, direct input ping, then Enter; (2) Ping www.163.com; (3) Ping 192.168.0.4; (TTL value of more than 200 other systems may be used in Linux, in several preliminary judgments can

  • Common Unix commands (rpm) 2010-05-31

    Common Unix commands Chapter directory and file manipulation commands 1.1 ls [Grammar]: ls [-RadCxmlnogrtucpFbqisf1] [directory or file ......] [Note]: ls command lists the files under the specified directory, the default directory for the current di

  • DB2 common statement summary 2010-06-03

    DB2 common statement summary 1, find the employee number, name, department and date of birth, date of birth is empty if the value, indicating an unknown date, sorted according to sector output, the date format yyyy-mm-dd. select emp_no, emp_name, dep

  • [Reserved] administrators must know: Windows common network commands Xiangjie 2010-07-23

    As a qualified network management, must have a strong technical skills, because the work is always among the problems encountered myriad. Today we'll look at network management system to study the need to know some of the Windows common network comma

  • Developers need to familiar with common Linux commands: redirection operator 2010-12-14

    Reprinted: http://blog.csdn.net/sfdev/archive/2008/07/29/2729680.aspx Remember finishing off a list of common Linux commands, but could not find how to find, and can only be one of the finishing; As a developer we landed linux may have something to d

  • DB2 common function (2) 2010-12-21

    1 DB2 common function, type conversion functions: decimal, double, Integer, smallint, real, Hex (arg), date, time, timestamp, char, varchar Common example: Into a string Oracle: select to_char (15.5000) from dual; DB2: select char (15.5000) from sysi

  • DB2 common commands Daquan 2011-01-06

    First, the commonly used commands 1. To establish a database DB2_GCB CREATE DATABASE DB2_GCB ON G: ALIAS DB2_GCB USING CODESET GBK TERRITORY CN COLLATE USING SYSTEM DFT_EXTENT_SZ 32 2. Connect to the database connect to sample1 user db2admin using 83

  • DB2 common commands (rpm) 2010-09-16

    1.1 start the DB2 service db2start 1.2 Close DB2 services db2stop 1.3 connect to the database db2 connect to databasename 1.4 query data data db2 "select * from tablename" 1.5 Query Data Structure db2 describe table tablename 1.6 delete the data

  • Common AT commands are (smslib) 2010-04-10

    ATZ soft reset modem. AT & K0 close the flow control. AT & K3 using the RTS / CTS flow control. AT & W0 write the current settings are saved to permanent memory in the modem's factory default configuration file 0. AT & Y0 when the MODEM in

  • Mysql common commands and common CRUD commands 2010-05-09

    Mysql Database: Mysql database versions prior to 4.1.0 does not support transactions, Mysql4.1.0 itself provides only limited support services. Therefore, the choice of Mysql version, try to select a higher version. The following records about progra

  • Common SSH commands under Linux VPS 2010-06-22

    End Distance learning how to use Putty (SSH) management Linux VPS, continue today to organize a VPSer rookies under the SSH on the Linux VPS common commands. List of operations: rm-rf mydir / * delete mydir directory * / cd mydir / * mydir directory

  • db2 frequently used commands (rpm) 2010-06-23

    First, commonly used commands 1. To establish a database DB2_GCB CREATE DATABASE DB2_GCB ON G: ALIAS DB2_GCB USING CODESET GBK TERRITORY CN COLLATE USING SYSTEM DFT_EXTENT_SZ 32 2. Connect to the database connect to sample1 user db2admin using 830120

  • source Insight common custom commands and some tips 2010-08-13

    Source Insight in to add a custom function, follow these steps: 1.Source Insight in, Options-> Custom Commands ...-> Add ..., New Command name casually written, I am the "Edit with Vim" 2.Run write: "C: \ Program Files \ Vim \ vim63 \

  • db2 commonly used commands 2011-07-19

    A commonly used commands 1 to establish a database DB2_GCB (based on the file system) CREATE DATABASE DB2_GCB ON G: ALIAS DB2_GCB USING CODESET GBK TERRITORY CN COLLATE USING SYSTEM DFT_EXTENT_SZ 32 db2 "CREATE DATABASE bipdb on 'E:' USING CODESET GB

  • DB2 common command set _ excerpts 2010-09-27

    First, the Basics 1, db2 connect to <database name> - connect to the local database name db2 connect to <database name> user <user name> using <password> - connect to remote database 2, db2 force application all - forcing all appli