DB2DIR/instance/db2icrt -a SERVER -u db2fenc1 db2inst1
1. Start an instance (db2inst1):
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.
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
Related Posts of DB2 for common commands
ActiveRecord is by far the best I have seen the ORM library, apart from DB2, supports all the mainstream databases. If you want to know how to use a separate Activerecord, please follow me. Introduce my system environment: OS: windows2003 DataBase: O ...
My local wamp server using one of the key package, only used mysql functions, today in the use of rake db: migrate when First reported a month can not be implemented, the next inquiry and found no mysql installed a gem, to install gem install mysql i ...
Update code after Action (No action responded to xxx) error. Check the code, has been updated. Change the action name, change the path is always error. Baffled. In the system under ps ax | grep mongrel, found that Mongrel can not find the process! Bu ...
In some special circumstances, we may be saved in the database connection information config.properties document, for example, make a install.jsp to modify config.properties documents, implementation of online information on the database configuration. At
# # Auto schema export # hibernate.hbm2ddl.auto create-drop # hibernate.hbm2ddl.auto create # hibernate.hbm2ddl.auto update # hibernate.hbm2ddl.auto validate The first is to create a table in the delete the original data, we can insert data, delete p ...
ROR is Ruby on Rails. Ruby is a well-known has been very good dynamic language It's dynamic language. Simple and easy. Dynamic languages are interpreted, but the performance may make a discount, but not absolute, because the application is complex, th
Database-driven update classes12-9i.jar Hibernate modify the configuration of the following code <bean/> <bean Lazy-init="true"> <property name="nativeJdbcExtractor"> <ref local="nativejdbcExtractor"/>
[Problem] Now, in the development of the so-called multi-storey JavaEE applications, data persistence layer is always essential, and "Automatic" of ORM - Hibernate, and "all-manual-type" of SqlMap - IBatis, equivalent data are Per ...
EJB3 persistence with Hibernate is very similar to the mechanism: Environment: Server: JBOSS5.0 Database: MySQL5.0 1. Set up a data source First of all, in jboss-5.0.0.GA \ server \ default \ deploy, the establishment of a database used to connect the dat
The use of hibernate, implementation of data persistence. Has the following several processes. One configuration database connection information. Hibernate.config 2 configuration mapping. 3 use: the use of the process are the following steps: 3.1: Ge ...