1. Download a free DB2 software from IBM's official website DB2 express-c and install it before the DB2 installation software on the computer is not license Expiration is not an installation. V8.2 License cannot use the Db2cmd command after it expires .
After installing the DB2 express-c Software, the results of using the local account yanjt2 in the db2cmd window to write commands have been error, should be insufficient authority, looking for a long time.
Local Users and groups can be found inside the group already has dbadmns Group, and has added yanjt2 .
But in the db2cmd command line under the db2set db2_grp_lookup=local,tokenlocal or error.
Find another post from the Internet:
New performance boosts IBM DB2 10.1 First Test
From
Db2set the command in the normal DB2 command line window will error:
C:\Program Files\ibm\sqllib\bin>db2set Db2_compatibility_vector=ora
db21009e must be run with full administrative privileges in the Command window to start this command.
Switch to the DB2 Administrator command-line window (the "Command Window-manager" mentioned in the installation section) to enter the command:
C:\Program Files\ibm\sqllib\bin>db2set Db2_compatibility_vector=ora
View current settings to see that the Db2_compatibility_vector parameter has been set to Ora:
C:\Program Files\ibm\sqllib\bin>db2set
Db2_ats_enable=yes
Db2_compatibility_vector=ora
Db2instowner=win-br1k22k3muc
db2portrange=60000:60003
Db2instprof=c:\programdata\ibm\db2\db2copy1
Db2comm=tcpip
Closing and launching an instance also requires entering commands in the DB2 Administrator command Line window:
C:\Program files\ibm\sqllib\bin>db2stop Force
2012-07-12 20:09:13 0 0 sql1064n db2stop processing succeeded.
sql1064n db2stop processing succeeded.
C:\Program Files\ibm\sqllib\bin>db2start
2012-07-12 20:09:27 0 0 sql1063n db2start processing succeeded.
sql1063n Db2start processing succeeded.
Delete and create a database you can enter commands in the normal DB2 command line window:
C:\Program files\ibm\sqllib\bin>db2 Drop Database Orcl
The SQL1035N database is currently in use. sqlstate=57019
First disconnect the database you want to delete:
C:\Program files\ibm\sqllib\bin>db2 Terminate
Db20000i TERMINATE Command completed successfully.
C:\Program files\ibm\sqllib\bin>db2 Drop Database Orcl
db20000i DROP DATABASE Command completed successfully.
C:\Program files\ibm\sqllib\bin>db2 "CREATE database ORCL using CodeSet UTF-8 TERRiTORY CN pagesize + K"
db20000i CREATE DATABASE Command completed successfully.
From
Knowing this is due to the new features of the newer DB2 10.1 .
Then open the DB2 command line processor:
Typing commands on this page,db2set db2_grp_lookup=local,tokenlocal Execution Success
Then go back to the normal Db2cmd page to execute the following script for the metabase , you can configure it properly,Yanjt2 has the appropriate permissions.
RELATED LINKS Reference:
Http://tech.it168.com/a2012/0911/1396/000001396438_5.shtml
http://www.ibm.com/developerworks/cn/downloads/im/udbexp/
Download free DB2 installation software, but before downloading, you need to register your IBM account
DB2 express-c 10.1 Database Installation Problem Resolution