db2 commonly used commands (II)

2010-11-19  来源:本站原创  分类:Database  人气:67 

17 Reconnect

connect reset

18. Interrupt the database connection
disconnect db2_gcb
19. View application

LIST APPLICATION;

20. Kill application

FORCE APPLICATION(0);
db2 force applications all ( Forced disconnect all applications from the database )

21. Lock table

lock table test in exclusive mode

22. Sharing

lock table test in share mode

23 shows the current user all tables

list tables

24. Lists the system tables

list tables for system

25 shows the current active database

list active databases

26 See command options

list command options

27 The system database directory

LIST DATABASE DIRECTORY

28. Tablespace

list tablespaces

29. Tablespace containers

LIST TABLESPACE CONTAINERS FOR
Example: LIST TABLESPACE CONTAINERS FOR 1

30. Display the user access to database

GET AUTHORIZATIONS

31. Start instance

DB2START

32 Stop instance

db2stop

33 table or view privileges

grant select,delete,insert,update on tables to user
grant all on tables to user WITH GRANT OPTION

34. Package privileges

GRANT EXECUTE
ON PACKAGE PACKAGE-name
TO PUBLIC

35. Mode privilege

GRANT CREATEIN ON SCHEMA SCHEMA-name TO USER
相关文章
  • db2 commonly used commands (II) 2010-11-19

    17 Reconnect connect reset 18. Interrupt the database connection disconnect db2_gcb 19. View application LIST APPLICATION; 20. Kill application FORCE APPLICATION(0); db2 force applications all ( Forced disconnect all applications from the database )

  • 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 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

  • About db2 commonly used commands 2010-08-11

    First, load the data: 1, load the default separator, default "" No. db2 "import from btpoper.txt of del insert into btpoper" 2, to specify the delimiter "|" Load db2 "import from btpoper.txt of del modified by coldel | i

  • db2 commonly used commands (a) 2010-11-19

    Today, the company's products had the honor to db2 migration, so there is the following experience. 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

  • db2 commonly used commands (b) 2010-11-19

    17. Reconnected connect reset 18. Interrupt the database connection disconnect db2_gcb 19. View application LIST APPLICATION; 20. Kill application FORCE APPLICATION(0); db2 force applications all ( Forces all applications to disconnect from the datab

  • db2 commonly used commands (c) 2010-11-19

    36. Database privileges grant connect,createtab,dbadm on database to user 37. Index privileges grant control on index index-name to user 38. Information to help (? XXXnnnnn) Cases :? SQL30081 39. SQL help (note the syntax of SQL statements) help stat

  • db2 commonly used commands Daquan 2010-09-20

    1, Load method of loading data: export & nbspto & nbsptempfile & nbspof & nbspdel & nbspselect * & nbspfrom & nbspTABLENAME & nbspwhere & nbspnot clean condition; load & nbspfrom & nbsptempfile & nbspof &

  • DB2 commonly used commands and some automated functions 2010-09-27

    db2 contact with a few days, and now these days use some of the repeated use of the name recorded for later use: Create a database db2 create db tbmprd using codeset UTF-8 territory CN The following command is linux command, the necessary design para

  • (R) Quick Reference: DB2 command line processor (CLP) in the commonly used commands 2010-11-11

    http://www.ibm.com/developerworks/cn/data/library/techarticles/0211yip2/ Quick Reference: DB2 command line processor (CLP) in the commonly used commands Maintained by the Paul Yip , IBM Toronto Lab Profile: Readers of this article are those of person

  • DB2 commonly used in SQL statements (1) 2010-04-30

    DB2 commonly used in SQL statements (1) 2009-09-22 16:29 2008-05-14 DB2 SQL statements commonly used in First, delete the database table some records of some of the same delete from tablename where only_Id not in (select min (only_id) from tablename

  • 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

  • UNIX systems commonly used commands 2010-10-28

    [Size = small] [/ size] UNIX systems commonly used commands log in and out chap 1 Log in Step 1 Step 2 new terminal telnet 192.168.0.23 Login Step 3 Step 4 the user login name password password user login successfully. At this time, the screen will s

  • Linux, mysql commonly used commands ubuntu (rpm) 2011-05-24

    Linux, mysql commonly used commands 1.linux start the mysql command: mysqladmin start / Ect / init.d / mysql start (in front of the mysql installation path) 2.linux next restart mysql command: mysqladmin restart / Ect / init.d / mysql restart (in fro

  • Oracle commonly used commands and functions 2010-10-09

    Oracle commonly used commands and functions to be finishing for later use, easy access. Commonly used commands: Connect sqlplus Command line, run cmd enter, such as the landing sys mode, the command is as follows: (1). Sqlplus "sys/zhb126 as sysdba&q

  • 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

  • Daquan Mysql commonly used commands, turn 2011-09-01

    Mysql commonly used commands show databases; display database create database name; create a database use databasename; Select database drop database name directly delete the database, not to remind the show tables; display tables describe tablename;

  • MYSQL database, a collection of commonly used commands 2010-05-05

    Mysql database is a multi-user, multi-threaded relational database is a client / server architecture of the application. It is the personal users and business users is free. Mysql database has the following advantages: 1. Simultaneous access to an un

  • Ubuntu Linux Operating System details commonly used commands 2010-05-24

    Ubuntu Linux Operating System details commonly used commands Udo apt - get install software, install the software command name sudo nautilus to open the file (with root permissions) su root switch to the "root" ls list the current directory file

  • Maven2 commonly used commands 2010-06-17

    from: http://guooo.javaeye.com/blog/280604 Maven2 commonly used commands Maven2 running command: mvn, Common commands are: mvn archetype: create: create a Maven project mvn compile: compile the source code mvn test-compile: compile the test code mvn