DB2 Database Daily Practical operation

1, Load method loading data:

Export to Tempfile of the Del select * from tablename where not scavenging condition;

Load from Tempfile of Del Modified by Delprioritychar to TableName nonrecoverable;

Description

In the unrelated data table export data, can take the form of concurrency, in order to improve efficiency;

TableName refers to the name of the table to be cleaned;

Modified by Delprioritychar prevents the presence of newline characters in the database record, causing the data to not be loaded;

Replace into replaces the contents of the current database, clears the existing data records and replaces them with the contents of the data file;

Nonrecoverable is loaded without log mode;

2, find the current application:

DB2 list application |grep Btpdbs;

3, delete the application currently in use:

DB2 "Force application (ID1,ID2,ID3)"

ID1,ID2,ID3 is the application number displayed in the list;

4, view the current application number of the state of execution:

DB2 get snapshot for application Agentid 299 |grep Row

5, view the database parameters:

DB2 get DB CFG for//current database can be omitted

6, modify the database log data:

DB2 Update DB CFG using < parameter name > < parameter value >

7, the use of Db2stop force:

The following error occurred while Bind was being made:

SQL0082C An error has occurred which has terminated.

SQL0092N No package was created because of previous errors.

SQL0091N Binding is ended with "3" Errors and "0" warnings.

The main is the table file is added lock, cannot continue to use;

Error when doing stop: db2stop

8/03/2005 21:46:53 0 0 sql1025n The database Manager is not stopped because databases are active.

SQL1025N The database manager is not stopped because databases are active.

You need to use the following command to resolve this problem: Db2stop force

08/03/2005 21:47:49 0 0 sql1064n db2stop processing was successful.

SQL1064N db2stop processing was successful.

Then start the database Db2start, connect the database db2s, and then bind again.