db2 part command
db2 ?
db2 list applications
db2 force application all
db2stop force
db2start
db2 backup db ksdbs
db2 backup db ksdbs online to “/backup/offline” with 4 buffers buffer 1024 parallelism 4 compress without prompting
db2 backup db ksdbs with 4 buffers buffer 1024 parallelism 4 compress without prompting
groupadd test
useradd -m -g test -d /home/test test
passwd test
db2 connect to sample
db2 grant connect on database to user test
db2 connect reset
db2 drop database ksdbs
db2 restore db ksdbs taken at 20130909163636
db2 restore db ksdbs from /db2home/db2inst1 taken at 20130909163636
db2 rollforward db ksdbs to end of logs and stop;
alter table ac.his_cust_trader_accoun add primary key (pbuno);
alter table tablename drop primary key;
alter table ac.cust_info_change alter column operatesource set data type varchar(254);
alter table ac.cust_info_change alter column operatesource set default 'valuse';
alter table ac.cust_trader_account add column openstatus char(1) not null with default '';
comment on column ac.cust_trader_account.openstatus is 'this is a test';
db2 describe indexes for table ac.his_cust_trader_account show detail;
db2ilist -- this command is list all database instance;
set -o vi
grep -r ‘energywise’ * --find from this catalogue
file crt_databse.sql /dev/filename --find the file type
dos2unix 123.sql -- dos to unix text file format converter
cat /etc/passwd | grep db2
groupadd db2fgrp3
useradd -d /home/db2inst3 -g db2grp3 -m -s /bin/bash db2inst3
cd /opt/IBM/db2/v10.1/instance/
./db2icrt -p 60000 -a SERVER -u db2fenc3 db2inst3
db2set db2comm=tcpip
db2set db2autostart=on
db2set db2codepage=1386
db2set db2country=86
vim /etc/services
db2inst3 60000/tcp #DB2 port
db2 update dbm cfg using SVCENAME 67901580
db2 list tablespaces show detail
db2 uncatalog db ksdbs
db2 uncatalog node db2node
db2 terminate
db2 catalog tcpip node test remote 10.10.12.187 server 60000
db2 catalog db ksdbs at node test
db2 terminate
db2set –all --list all have reseted
db2 connect to ksdbs user user_name using password
db2 update dbm cfg SVCENAME db2inst3
db2 create db ksdbs using codeset gbk territory cn
db2 connect to ksdbs
db2 -tvf crt_db.sql
useradd -d /home/back3 -g db2grp3 -m -s /bin/bash back3
passwd back3
source .bash_profile
unzip yuan_code.zip
ln /usr/include/sys/timeb.h /usr/include/timeb.h
vim /home/back3/bccbin/kssbmp/ksmbcc.ini
basefuncno=2222
servercount=1
server1=10.10.10.34:20000:222
sbmpbu.ini
vim /home/back3/bccbin/kssbmp/sbmpbu.ini
./decode –e db2inst3
/home/back3/bccbin/kssbmp/sbmpbu.ini
password=088258a90f86e86f
vim $home/make/environment.include
ifeq ($(user),)
db2conn := @db2 connect to ksdbs
else
db2conn := @db2 connect to ksdbs user $(user) using $(pwd)
endif
linux
shutdown -h now
shutdown -h 20:25
shutdown -r +30 'the system will reboot'
init 0
mkdir -p /yan/zheng/qing --parents
mkdir -m 711 test2 --mode
tail -n 20 /etc/man.config
head -n 20 /etc/man.config
cat shell.sh | nl
tail yanzhengqing.info -n 30
head -n 20 /etc/man.config | tail -n 10
which whoami
updatedb -- root environment
locate yan -n 10
find /home -user vbird
find / -name passwd
find /var -type s
find / -perm +7000 -exec ls -all {} \;
ifconfig eth0 192.168.0.20 netmask 255.255.255.0
route add default gw 192.168.0.254
/etc/init.d/networking restatr
service xinetd restart
/etc/xinetd.d/krb5-telnet
df -a include dummy file systems
ln -s /bin /root/bin
df -T print file system type
df -h print sizes in human readable format
fdisk -l List the partition tables for the specified devices and then exit.
partprobe
mkfs -t ext3 /dev/hdc6
fsck -C -f -t ext3 /dev/hdc6 --check filesystem
badblocks -sv /dev/hdc6 --check badtrack
mount -a Mount all filesystems (of the given types) mentioned in fstab
mount -l Add the ext2, ext3, ext4 and XFS labels in the mount output
mount -t The argument following the -t is used to indicate the file sys-temtype.
mkdir /mnt/hdc6
mount /dev/hdc6 /mnt/hdc6
mount -t iso9660 /dev/cdrom /media/cdrom
mount -t vfat -o iocharset=cp950 /dev/sda1 /mnt/flash
mount --bind /home /mnt/home Remount a subtree somewhere else (so that its contents are available in both places). See above.
/etc/fstab
mount -o loop /root/centos5.2_x86_64.iso /mnt/centos_dvd
runlevel
yum install ncompress
gzip -v man.config
bzip2 -z man.config
bzcat man.config.bz2
bzip2 -d man.config.bz2
tar -jcv -f /root/system.tar.bz2 --exclude=/root/etc* --exclude=/root/system.tar.bz2 /etc /root
df -h
dump -S /dev/sda8
dump -0u -f /root/sda8.dump /dev/sda8
dump -W
restore -i -f /root/etc.dump
mkisofs -r -v -o /tmp/system.img /root /home /etc
dump -0j -f /root/etc.dump.bz2 /etc
restore -t -f /root/boot.dump
restore -C -f /root/boot.dump
mount -o loop home.img /mnt
mkisofs -r -V 'linux_file' -o /tmp/system.img -m /home/lost+found -graft-point /root=/root /home=/home /etc=/etc
dd if=/etc/passwd of=/tmp/passwd.back
dd if=/dev/hdc of=/tmp/mbr.back bs=512 count=1
dd if=/dev/hdc1 of=/tmp/boot.whole.disk
find /boot -print
cpio -ocvB > /dev/st0
cpio -idvc < /dev/st0
:set number
:set nonumber :set nonu
:n1,n2 w [filename]
:! command --goto shell desktop
:set nohlsearch
:set noautoindent --stand in line
:set showmode
:syntax on --show diffent clours
Visual Block [Ctrl]+v
alias lm='ls -al'
echo $myname
unset name
source ~/.bashrc
ls -al /etc | less
find /home -name .bashrc > list_right 2> list_error
find /home -name .bashrc 2> /dev/null
find /home -name .bashrc &> list
find /home -name .bashrc > list 2>&1
cat > catfile
cat > catfile << "eof" --input information end of eof
sync; sync; shutdown -h now
ls /tmp/abc && touch /tmp/abc/hehe -- one line excute two command
ls /tmp/abc || mkdir /tmp/abc
echo $PATH | cut -d ':' -f 3,5
cat /etc/passwd | sort -t ':' -k 3
last | cut -d ' ' -f1 | sort
last | cut -d ' ' -f1 | sort | uniq -c
cat /etc/man.config | wc
last | tee last.list | cut -d " " -f1
head -n 3 /etc/passwd /etc/shadow
join -t ':' /etc/passwd /etc/shadow
paste /etc/passwd /etc/shadow
grep '^MANPATH' /etc/man.config | head -n 3 | expand -t 6 - | cat -A --^ is the string on the head line
split -b 300k /etc/termcap termcap
cat termcap* >> termcapback
tar -cvf - /home | tar -xvf -
dmesg | grep -n -A3 -B2 --color=auto 'eth'
grep -n 'the' regular_express.txt --output line number
grep -vn 'the' regular_express.txt --output out of the serch string
grep -in 'the' regular_express.txt -ignore case
grep -n 't[ae]st' regular_express.txt --only march one char
grep -n '[^g]oo' regular_express.txt
grep -n '[^a-z]oo' regular_express.txt
grep -n '^the' regular_express.txt
grep -n '^[a-z]' regular_express.txt
grep -n '^[^a-zA-Z]' regular_express.txt
grep -n '\.$' regular_express.txt -- $ is mean end of line
grep -n '^$' regular_express.txt
grep -n 'g..d' regular_express.txt -- .is mean anything of char but only one char
grep -n 'g.*g' regular_express.txt --.* is mean null or more same char
grep -n 'o\{2\}' regular_express.txt -- \{ is mean { and also \} is } . all of this is mean find include two o char in the string
grep -n 'go\{2,5\}g' regular_express.txt -- all os this is mean find distween two then five o char in the string
nl /etc/passwd | sed '2,5d' --output line number and stand in line then delete 2-5line
nl /etc/passwd | sed '2a drink tea' --add drink tea after 2line
nl /etc/passwd | sed '2,5c No 2-5 number' --replace 2-5 for No 2-5 number
nl /etc/passwd | sed -n '5,7p'
ifconfig eth0 | grep 'inet addr:'|sed 's/^.*addr://g'|sed 's/Bcast.*$/hello world ! /g' --s mean replace g is mean all line same strings else only the first one
sed -i '$a # This is a test' regular_express.txt -- i is mean direct modify $ is mean last line end
grep -v '^$' regular_express.txt | grep -v '^#' -- v mean opposite
egrep -v '^$|^#' regular_express.txt
egrep -n 'go+d' regular_express.txt -- + mean one or more before it char
egrep -n 'go?d' regular_express.txt -- ? mean zero or one before ith char
egrep -n 'gd|good|dog' regular_express.txt
egrep -n 'g(la|oo)d' regular_express.txt
grep -n '[!>]' regular_express.txt -- [ ] all char only one march
last -n 5 | awk '{print $1 "\t" $3}'
cmp passwd.old passwd.new
netstat -tuln
newgrp users --make users add into new group. this users is group name.
useradd -u 700 -g users vbird2
usermod -c "VBird's test" vbird2 -- c means notes
groupmod -g 201 -n mygroup group1
alias lm='ls -al'
db2 ?
db2 list applications
db2 force application all
db2stop force
db2start
db2 backup db ksdbs
db2 backup db ksdbs online to “/backup/offline” with 4 buffers buffer 1024 parallelism 4 compress without prompting
db2 backup db ksdbs with 4 buffers buffer 1024 parallelism 4 compress without prompting
groupadd test
useradd -m -g test -d /home/test test
passwd test
db2 connect to sample
db2 grant connect on database to user test
db2 connect reset
db2 drop database ksdbs
db2 restore db ksdbs taken at 20130909163636
db2 restore db ksdbs from /db2home/db2inst1 taken at 20130909163636
db2 rollforward db ksdbs to end of logs and stop;
alter table ac.his_cust_trader_accoun add primary key (pbuno);
alter table tablename drop primary key;
alter table ac.cust_info_change alter column operatesource set data type varchar(254);
alter table ac.cust_info_change alter column operatesource set default 'valuse';
alter table ac.cust_trader_account add column openstatus char(1) not null with default '';
comment on column ac.cust_trader_account.openstatus is 'this is a test';
db2 describe indexes for table ac.his_cust_trader_account show detail;
db2ilist -- this command is list all database instance;
set -o vi
grep -r ‘energywise’ * --find from this catalogue
file crt_databse.sql /dev/filename --find the file type
dos2unix 123.sql -- dos to unix text file format converter
cat /etc/passwd | grep db2
groupadd db2fgrp3
useradd -d /home/db2inst3 -g db2grp3 -m -s /bin/bash db2inst3
cd /opt/IBM/db2/v10.1/instance/
./db2icrt -p 60000 -a SERVER -u db2fenc3 db2inst3
db2set db2comm=tcpip
db2set db2autostart=on
db2set db2codepage=1386
db2set db2country=86
vim /etc/services
db2inst3 60000/tcp #DB2 port
db2 update dbm cfg using SVCENAME 67901580
db2 list tablespaces show detail
db2 uncatalog db ksdbs
db2 uncatalog node db2node
db2 terminate
db2 catalog tcpip node test remote 10.10.12.187 server 60000
db2 catalog db ksdbs at node test
db2 terminate
db2set –all --list all have reseted
db2 connect to ksdbs user user_name using password
db2 update dbm cfg SVCENAME db2inst3
db2 create db ksdbs using codeset gbk territory cn
db2 connect to ksdbs
db2 -tvf crt_db.sql
useradd -d /home/back3 -g db2grp3 -m -s /bin/bash back3
passwd back3
source .bash_profile
unzip yuan_code.zip
ln /usr/include/sys/timeb.h /usr/include/timeb.h
vim /home/back3/bccbin/kssbmp/ksmbcc.ini
basefuncno=2222
servercount=1
server1=10.10.10.34:20000:222
sbmpbu.ini
vim /home/back3/bccbin/kssbmp/sbmpbu.ini
./decode –e db2inst3
/home/back3/bccbin/kssbmp/sbmpbu.ini
password=088258a90f86e86f
vim $home/make/environment.include
ifeq ($(user),)
db2conn := @db2 connect to ksdbs
else
db2conn := @db2 connect to ksdbs user $(user) using $(pwd)
endif
linux
shutdown -h now
shutdown -h 20:25
shutdown -r +30 'the system will reboot'
init 0
mkdir -p /yan/zheng/qing --parents
mkdir -m 711 test2 --mode
tail -n 20 /etc/man.config
head -n 20 /etc/man.config
cat shell.sh | nl
tail yanzhengqing.info -n 30
head -n 20 /etc/man.config | tail -n 10
which whoami
updatedb -- root environment
locate yan -n 10
find /home -user vbird
find / -name passwd
find /var -type s
find / -perm +7000 -exec ls -all {} \;
ifconfig eth0 192.168.0.20 netmask 255.255.255.0
route add default gw 192.168.0.254
/etc/init.d/networking restatr
service xinetd restart
/etc/xinetd.d/krb5-telnet
df -a include dummy file systems
ln -s /bin /root/bin
df -T print file system type
df -h print sizes in human readable format
fdisk -l List the partition tables for the specified devices and then exit.
partprobe
mkfs -t ext3 /dev/hdc6
fsck -C -f -t ext3 /dev/hdc6 --check filesystem
badblocks -sv /dev/hdc6 --check badtrack
mount -a Mount all filesystems (of the given types) mentioned in fstab
mount -l Add the ext2, ext3, ext4 and XFS labels in the mount output
mount -t The argument following the -t is used to indicate the file sys-temtype.
mkdir /mnt/hdc6
mount /dev/hdc6 /mnt/hdc6
mount -t iso9660 /dev/cdrom /media/cdrom
mount -t vfat -o iocharset=cp950 /dev/sda1 /mnt/flash
mount --bind /home /mnt/home Remount a subtree somewhere else (so that its contents are available in both places). See above.
/etc/fstab
mount -o loop /root/centos5.2_x86_64.iso /mnt/centos_dvd
runlevel
yum install ncompress
gzip -v man.config
bzip2 -z man.config
bzcat man.config.bz2
bzip2 -d man.config.bz2
tar -jcv -f /root/system.tar.bz2 --exclude=/root/etc* --exclude=/root/system.tar.bz2 /etc /root
df -h
dump -S /dev/sda8
dump -0u -f /root/sda8.dump /dev/sda8
dump -W
restore -i -f /root/etc.dump
mkisofs -r -v -o /tmp/system.img /root /home /etc
dump -0j -f /root/etc.dump.bz2 /etc
restore -t -f /root/boot.dump
restore -C -f /root/boot.dump
mount -o loop home.img /mnt
mkisofs -r -V 'linux_file' -o /tmp/system.img -m /home/lost+found -graft-point /root=/root /home=/home /etc=/etc
dd if=/etc/passwd of=/tmp/passwd.back
dd if=/dev/hdc of=/tmp/mbr.back bs=512 count=1
dd if=/dev/hdc1 of=/tmp/boot.whole.disk
find /boot -print
cpio -ocvB > /dev/st0
cpio -idvc < /dev/st0
:set number
:set nonumber :set nonu
:n1,n2 w [filename]
:! command --goto shell desktop
:set nohlsearch
:set noautoindent --stand in line
:set showmode
:syntax on --show diffent clours
Visual Block [Ctrl]+v
alias lm='ls -al'
echo $myname
unset name
source ~/.bashrc
ls -al /etc | less
find /home -name .bashrc > list_right 2> list_error
find /home -name .bashrc 2> /dev/null
find /home -name .bashrc &> list
find /home -name .bashrc > list 2>&1
cat > catfile
cat > catfile << "eof" --input information end of eof
sync; sync; shutdown -h now
ls /tmp/abc && touch /tmp/abc/hehe -- one line excute two command
ls /tmp/abc || mkdir /tmp/abc
echo $PATH | cut -d ':' -f 3,5
cat /etc/passwd | sort -t ':' -k 3
last | cut -d ' ' -f1 | sort
last | cut -d ' ' -f1 | sort | uniq -c
cat /etc/man.config | wc
last | tee last.list | cut -d " " -f1
head -n 3 /etc/passwd /etc/shadow
join -t ':' /etc/passwd /etc/shadow
paste /etc/passwd /etc/shadow
grep '^MANPATH' /etc/man.config | head -n 3 | expand -t 6 - | cat -A --^ is the string on the head line
split -b 300k /etc/termcap termcap
cat termcap* >> termcapback
tar -cvf - /home | tar -xvf -
dmesg | grep -n -A3 -B2 --color=auto 'eth'
grep -n 'the' regular_express.txt --output line number
grep -vn 'the' regular_express.txt --output out of the serch string
grep -in 'the' regular_express.txt -ignore case
grep -n 't[ae]st' regular_express.txt --only march one char
grep -n '[^g]oo' regular_express.txt
grep -n '[^a-z]oo' regular_express.txt
grep -n '^the' regular_express.txt
grep -n '^[a-z]' regular_express.txt
grep -n '^[^a-zA-Z]' regular_express.txt
grep -n '\.$' regular_express.txt -- $ is mean end of line
grep -n '^$' regular_express.txt
grep -n 'g..d' regular_express.txt -- .is mean anything of char but only one char
grep -n 'g.*g' regular_express.txt --.* is mean null or more same char
grep -n 'o\{2\}' regular_express.txt -- \{ is mean { and also \} is } . all of this is mean find include two o char in the string
grep -n 'go\{2,5\}g' regular_express.txt -- all os this is mean find distween two then five o char in the string
nl /etc/passwd | sed '2,5d' --output line number and stand in line then delete 2-5line
nl /etc/passwd | sed '2a drink tea' --add drink tea after 2line
nl /etc/passwd | sed '2,5c No 2-5 number' --replace 2-5 for No 2-5 number
nl /etc/passwd | sed -n '5,7p'
ifconfig eth0 | grep 'inet addr:'|sed 's/^.*addr://g'|sed 's/Bcast.*$/hello world ! /g' --s mean replace g is mean all line same strings else only the first one
sed -i '$a # This is a test' regular_express.txt -- i is mean direct modify $ is mean last line end
grep -v '^$' regular_express.txt | grep -v '^#' -- v mean opposite
egrep -v '^$|^#' regular_express.txt
egrep -n 'go+d' regular_express.txt -- + mean one or more before it char
egrep -n 'go?d' regular_express.txt -- ? mean zero or one before ith char
egrep -n 'gd|good|dog' regular_express.txt
egrep -n 'g(la|oo)d' regular_express.txt
grep -n '[!>]' regular_express.txt -- [ ] all char only one march
last -n 5 | awk '{print $1 "\t" $3}'
cmp passwd.old passwd.new
netstat -tuln
newgrp users --make users add into new group. this users is group name.
useradd -u 700 -g users vbird2
usermod -c "VBird's test" vbird2 -- c means notes
groupmod -g 201 -n mygroup group1
alias lm='ls -al'