DB2 for common commands

Create an instance of

DB2DIR/instance/db2icrt -a SERVER -u db2fenc1 db2inst1

1. Start an instance (db2inst1):

db2start

View examples of port

db2 get dbm cfg |grep SVCENAME

Then go to / etc / services to find the above command to find services and corresponding port number.

View all examples.

db2ilist

List all databases

db2 list database directory

. Create the database:

db2 create db test

. This database configuration parameter information

db2 get db cfg for test|more

. Delete the database:

db2 drop db test

Connect to the database

db2 create database TEXT

The system a user test_1

db2 on how to give a new user license

Specific operation is as follows:

1、db2 connect to test
2、db2 grant connect on database to user test1
3、db2 disconnect test
4、db2 connect to dssdb user test_1 using test_1
分类:Database 时间:2010-04-16 人气:211
分享到:
blog comments powered by Disqus

相关文章

  • DB2 database table lock mode description 2010-11-07

    DB2 at the table level lock can lock the following ways: Table I: DB2 database table lock mode The following table locks for several DB2 database models further elaborated: IS, IX, SIX way for table row lock level and the need to meet, they can preve

  • Mysql Database hot standby configuration 2010-10-24

    1. MySQL database is not an incremental backup mechanism, when the data is too big when the backup is a big problem. Fortunately, the main mysql database provides a mechanism from a backup, in fact, the master database of all the data simultaneously

  • DB2 database configuration example of the joint (Reprinted) 2010-06-21

    As the two machines need to use to read data on the demand for db2 database, db2 database, so use a joint database I use the database version is 9.7, and the two machines installed db2, the following configuration are in the customer machine configur

  • Hibernate support package DBCP database connection pool configuration 2009-04-09

    Hibernate support package DBCP database connection pool configuration. A brief description of the configuration process: (Just a personal feeling, if questions are welcome to show) Required packages: Commons-Pool (download Address: http://jakarta.apa

  • Build a database using Hibernate configuration file 2010-03-29

    Build a database using Hibernate configuration file At present, many people use Hibernate as a persistence layer, if we have to write the configuration file poweracl.hbm.xml, is no longer struggling to write SQL-DDL. In addition to using tools Schema

  • Weblogic access the oracle database connection pool configuration 2010-04-20

    Weblogic access the oracle database connection pool configuration in Weblogic access oracle database JDBC connection pool in three ways you can configure one in the weblogic console in accordance with the following configuration to establish connecti

  • Oracle database installation and configuration (a) 2011-04-11

    Oracle database installation and configuration (a): http://coderdream.iteye.com/blog/493585

  • tomcat6 database connection pool configuration in detail 2011-09-08

    tomcat6 database connection pool configuration in detail I first explain the configuration of the environment under tomcat version is apache-tomcat-6.0.33 non-installation version, the path is D: \ Java \ apache-tomcat-6.0.33, tomcat does not affect

  • Oracle Net Configuration Assistant configuration study 2010-05-21

    Oracle Net Configuration Assistant configuration Learning Collection Net Configuration Assistant configuration steps: Suppose the database server where the IP address: 192.168.0.1 Database instance name: ora92 User Name: umap Password: umap Step one:

  • hibernate source of a class of the Configuration object Configuration 2010-04-13

    Hibernate's friends used to know the meaning of the following code, do not know it, look at this article also senseless! Boot code: Configuration cfg = new Configuration (); cfg.addClass (User.class); cfg.configure (); SchemaExport export = new Schem

iOS 开发

Android 开发

Python 开发

JAVA 开发

开发语言

PHP 开发

Ruby 开发

搜索

前端开发

数据库

开发工具

开放平台

Javascript 开发

.NET 开发

云计算

服务器

Copyright (C) codeweblog.com, All Rights Reserved.

CodeWeblog.com 版权所有 黔ICP备15002463号-1

processed in 0.320 (s). 13 q(s)