Posts

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

DB2 related

The following notes are for myself only. Whoever happened to accidentally read these notes, please do not ask any question. SQL2413N Online backup is not allowed because the database is not recoverable or a backup pending condition is in effect. Explanation Online backup cannot be performed while the database is not logging for forward recovery as forward recovery will be required at restore time. Forward recovery is placed into effect by setting either the database configuration LOGARCHMETH1 or LOGARCHMETH2 and then performing an offline backup of the database. User response Execute an offline backup or reconfigure the database for roll-forward recovery and issue an offline backup so that subsequent online backups will be allowed. ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ The operation failed because the specified database cannot be connected to in the mode requested.  SQLSTATE=57019 Resolving the problem The issue can be addressed by using th

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

How to add host into DNS server using Command Line in Windows Server 2003?

How to add host into DNS server using Command Line in Windows Server 2003? If you have a lot of hosts that need to be added into DNS server, you can use dnscmd.exe command to make your job easier. If your server doesn't have this command, you might need to download Windows Support Tools from Microsoft. Find it yourself! As example, you want to add host sh-hr01 with IP Address 192.168.202.5 into sh.com domain using sh-ns server (this is a DNS server), execute this command:     dnscmd sh-ns /RecordAdd sh.com sh-hr01 A 192.168.202.5     Then, you might need to add this host address into Reverse Pointer Zone (in this example is 168.192.in-addr.arpa), this is the command:     dnscmd sh-ns /RecordAdd 168.192.in-addr.arpa 5.202 PTR sh-hr01.sh.com     You can use this command as a batch command, so that you can add a lot of hosts easier.. Got it!?

GPS menggunakan telefon tangan tanpa peranti GPS

Image
Ramai orang ada alat GPS sekarang ni. Ada yang siap dalam telefon tangan sekali pulak tu. Kalau nak gi tempat2 yang tak biasa, sangat membantu la benda ni. Rasa di hati ndak juga, tapi bajet tak ada.. lagipun bukan hari2 guna benda tu kan.. yang ada cuma telefon tangan model yang agak lama, contohnya macam aku punya.. sony ericsson k530i.. dah lebih dua tahun guna ok lagi.. bley berwap.. ada skrin berwarna.. ada jowo lagi.. Hah.. boleh la tu.. tak payah tukar henpon baru.. Apa nak buat? dari henpon tu.. masuk webpage di URL ini http://m.google.com/maps Nanti ada la link untuk korang download sesuai dengan model henpon tu. http://www.google.com/mobile/maps/     Lepas siap install.. dapat la peta ala2 gps... Walaupun kedudukan kita tak setepat gps, agak membantu juga untuk mencari arah.. cubalah.. Pastikan langgan data sekali.. kalau ambik voice je.. siap la nanti bayar bil banyak!

Nama fail tak sah

Dalam OS MS-DOS termasuk MS-windows, ada beberapa nama simpanan yang pengguna tidak boleh gunakan  untuk menamakan fail atau folder. Nama2 ini khusus untuk pemacu alatan2 sistem. Nama2 tu macam kat bawah ni siap dengan penjelasan sekali.   Nama Fungsi ---- -------- CON Papan kekunci dan paparan PRN Alatan senarai sistem, biasanya pot bersiri AUX Alatan bersekutu, biasanya pot selari CLOCK$ Jam waktu sebenar sistem NUL Alat bit-bucket A: - Z: Huruf pemacu COM1 Pot perhubungan bersiri pertama LPT1 Pot pencetak selari pertama LPT2 Pot pencetak selari kedua LPT3 Pot pencetak selari ketiga COM2 Pot perhubungan bersiri kedua COM3 Pot perhubungan bersiri ketiga COM4 Pot perhubungan bersiri keempat   Disamping itu, terdapat juga aksara2 khas yang tidak boleh digunakan sebagai sebahagian dari nama fail. Senarainya adalah:    \ / * : ? " < > |   Aksara2 tersebut mempunyai fungsi tersendiri di dalam perj

System State backup using CMD

Image
How to backup system state using dos command line? You can either type this command at the command line or in the cmd batch file as well (in one line). ntbackup backup systemstate /J "System State Backup Job" /F "D:\BAK.BAK\%COMPUTERNAME%_system_state_backup.bkf" The parameter %COMPUTERNAME% will include your computer name as part of backup file name. You also can put a current date as part of the file name. To do so, add this parameter: %date:~-4,4%%date:~-10,2%%date:~-7,2% or in full command, it would be like this: ntbackup backup systemstate /J "System State Backup Job" /F "D:\BAK.BAK\%date:~-4,4%%date:~-10,2%%date:~-7,2%_%COMPUTERNAME%_system_state_backup.bkf " Anyway, the file name arrangement is belongs to you. You don't need to follow exactly. " System State Backup Job" is a description that you can put it as you like, it might be in your tongue language. If the date today is October 27, 2009 and your computer name is mypc,