db2 - backup

Take an OFFLINE backup

db2 connect to

db2 quiesce database immediate force connections

db2 connect reset

db2 backup database to compress without prompting

after backup completes:

db2 connect to

db2 unquiesce database

db2 connect reset

Take an ONLINE Backup

db2 backup db to online compress

or use a background process on a linux/unix machine

nohup db2 backup db to online compress &

List recent backups and where they are stored

=>db2 list history backup all for

Check the integrity of a backup image

=>db2ckbkp

Restore from Incremental Backup Automatic

=>db2 restore db incremental automatic taken at

If you need to restore an incremental backup manually this command will give you the required previous backups.

=>db2ckrst -d -t

Comments

Post a Comment

Popular posts from this blog

Forgot EVA Command View admin userid/password

Image
How to change or recover HP EVA Command View userid/password? You are the new system engineer and you want to manage one HP Storageworks using EVA Command View but you dont have an id/password for it. You can simply change the id/password of it, provided you have an administrator id (regardless it is domain/local admin) for the server where the EVA Command View is installed. Find the local user account for that particular machine and look for HP Storage Admins group. Check the properties and find out who is the member of that group. As example below, eva is the userid I am looking for. You can change the password of this userid or you can even add a new member for this group. Now, you can login into EVA Command View using this id and new password.
Read more

Manage wtmp Log Size In Aix

1. CONVERT WTMP FILE TO A  TEXT FILE AND REMOVE UNWANTED ENTRIES. Covert the wtmp file to readable ascii text file: /usr/sbin/acct/fwtmp < /var/adm/wtmp > /tmp/wtmp.ascii.txt We can calculate number of lines of wtmp.ascii.txt file; # cat /tmp/wtmp.ascii.txt|wc -l     3010110 See... how big it is! We can use text editor such as vi editor or other text editor to remove unwanted entry from this wtmp.ascii.txt file. However, if the file is too big, some text editor software is unable to open it. As an option, we can keep only last 1,500,500 lines (it is my number, you can choose your number yourself); tail -1500500 /tmp/wtmp.ascii.txt >> /tmp/wtmp.ascii2.txt We might edit the smaller wtmp.ascii2.txt file using text editor. 2. CONVERT THE TEXT FILE BACK TO WTMP FORMAT AND COPY TO THE DEFAULT LOCATION Use the trimmed file. /usr/sbin/acct/fwtmp -ic < tmp/wtmp.ascii2.txt>  /var/adm/wtmp 3. REMOVE TEMPORARY FILES (optional). rm /tmp/wtmp.ascii.tx
Read more

Network Connections Type

ATM (asynchronous transfer mode) - the protocol used to "gather" DSL traffic from users and forward it to a DSLAM, which consolidates traffic across the backbone network. Carries data in fixed-length frames of 53 bytes each. ATU-C (ADSL Termination Unit - Central Office) - the downstream channel. ATU-R (ADSL Termination Unit - Remote) - the upstream channel. CAP (carrierless amplitude/phase modulation) - the original ADSL modulation approach in which the signal frequency range is divided into voice (0-4 KHz), upstream data, and downstream data. DMT (discrete multitone) is now the preferred modulation alternative over CAP. CDSL (Consumer DSL) - a trademarked version of DSL from Rockwell that is somewhat slower than ADSL (1 Mbps downstream, probably less upstream) but has the advantage that a "splitter" does not need to be installed at the user's end. CDSL uses its own carrier technology rather than DMT or CAP ADSL technology. DMT (Discrete Multito
Read more