Some daily practical operations of DB2 database (1)

Source: Internet
Author: User
Tags id3

The following article mainly tells you about some daily practical operations of the DB2 database. I accidentally found a daily practical operation on the DB2 database on a website a few days ago, so I will share it with you today, the following is a description of the specific solution. I hope it will help you in your future study.

1. Load data:

Export to tempfile of del select * from TABLENAME where not clearing condition;

  1. load from tempfile of del modified by delprioritychar replace into TABLENAME nonrecoverable; 


When the export data of unrelated data tables is export, it can be in the form of concurrency to improve efficiency;

TABLENAME indicates the name of the table to be cleared;

Modified by delprioritychar prevents the database records from being loaded due to line breaks;

Replace into replaces the content in the current DB2 database with the content of the data file;

Nonrecoverable load without logs;

2. Search for the current application:

  1. db2 list application |grep BTPDBS; 

3. Delete the application currently in use:

  1. db2 "force application (Id1,Id2,Id3)" 

Id1, Id2, and Id3 are the application numbers displayed in the List;

4. view the execution status of the current application number:

  1. db2 get snapshot for application agentid 299 |grep Row 

5. view database parameters:

Db2 get db cfg for // The current DB2 database can be omitted

6. Modify the Database Log Data:

Db2 update db cfg using <Parameter Name> <parameter value>

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.