查看pv的位置
# lsdev -Cc disk
hdisk0 Available 01-08-00 SAS Disk Drive
hdisk1 Available 01-08-00 SAS Disk Drive
hdisk2 Available 04-09-01 MPIO DS5020 Disk
hdisk3 Available 04-09-01 MPIO DS5020 Disk
hdisk4 Available 04-09-01 MPIO DS5020 Disk
或
# lscfg -vpl hdisk2
hdisk2 U78A0.001.DNWGH49-P1-C5-T2-W20150080E52C8354-L0 MPIO DS5020 Disk
Manufacturer................IBM
Machine Type and Model......1814 FAStT
ROS Level and ID............31303630
Serial Number...............
Device Specific.(Z0)........0000053245005032
Device Specific.(Z1)........
PLATFORM SPECIFIC
Name: disk
Node: disk
Device Type: block
查看VG上挂载了哪些LV
# lsvg -l datavg
datavg:
LV NAME TYPE LPs PPs PVs LV TATE MOUNT POINT
cpsdatalv jfs2 80 80 3 open/syncd /cpsdata
epsdatalv jfs2 40 40 3 open/syncd /epsdata
cmsdatalv jfs2 40 40 3 open/syncd /cmsdata
loglv00 jfs2log 1 1 1 open/syncd N/A
fslv01 jfs2 10 10 1 open/syncd /home/db2inst1
fslv02 jfs2 10 10 1 open/syncd /home/db2inst2
fslv03 jfs2 10 10 1 open/syncd /home/db2inst3
==================================================
银联数据DB2数据库payment2库建立的位置在rootvg上,位置不正确。
在datavg上重新建立一个paymentlv,在挂载在/payment2目录下。
LV,FS:创建、挂载、删除
# mkdir /BAK //创建挂载点
# mklv -t jfs2 -y bak_lv rootvg 20g //创建逻辑卷
bak_lv
//创建逻辑卷bak_lv,在卷组rootvg上,空间为20G。
# crfs -v jfs2 -d bak_lv -A yes -m /BAK //创建文件系统,-A是自动挂载。
File system created successfully.
20970676 kilobytes total disk space.
New File System size is 41943040
# mount /BAK //挂载文件系统
# umount /BAK //卸载
# rmfs /dev/bak_lv //删除文件系统
rmlv: Logical volume bak_lv is removed.
DB2中cms用户下,db2inst3例下,cms数据库中,m_mer表用“select * from m_mer“查询,汉字显示正常,导出之后显示为乱码,经过分析,是因为导出时字符转码设置不正确.