抓取的log如下：
BBBC,000,hdisk0:
BBBC,001,LV NAME LPs PPs DISTRIBUTION MOUNT POINT
BBBC,002,hd10opt 32 32 28..00..04..00..00 /opt
BBBC,003,hd2 71 71 00..04..31..36..00 /usr
BBBC,004,hd9var 84 84 00..46..38..00..00 /var
BBBC,005,hd3 80 80 00..00..80..00..00 /tmp
BBBC,006,hd1 1 1 00..00..01..00..00 /home
BBBC,007,hd5 1 1 01..00..00..00..00 N/A
BBBC,008,hd6 11 11 00..04..00..00..07 N/A
BBBC,009,hd8 1 1 00..00..01..00..00 N/A
BBBC,010,hd4 3 3 00..00..03..00..00 /
BBBC,011,Plv_cicsregion 16 16 00..16..00..00..00 /var/cics_regions
BBBC,012,Plv_cicsserver 8 8 08..00..00..00..00 /var/cics_servers
BBBC,013,log_SFS_01 2 2 02..00..00..00..00 N/A
BBBC,014,sfs_SFS_01 2 2 02..00..00..00..00 N/A
BBBC,015,oralv 232 232 115..00..00..00..117 /u01
BBBC,016,lg_dumplv 8 8 00..08..00..00..00 N/A
BBBC,017,livedump 2 2 00..02..00..00..00 /var/adm/ras/livedump
BBBC,018,fslv00 80 80 00..80..00..00..00 /software
BBBC,019,waslv 160 160 04..00..00..124..32 /websphere
BBBC,020,hd11admin 1 1 00..00..01..00..00 /admin
BBBC,021,hdisk0 00f61a0489cfa916 rootvg active
BBBC,022,hdisk1 00f61a04034541a8 None
BBBC,023,hdisk2 00f61a04460c09e7 None
BBBC,024,hdisk3 none None
BBBC,025,hdisk4 none None
BBBC,026,hdisk5 none None
BBBC,027,hdisk6 none None
獲取log第一列的BBBC作為表名建表，獲取log第二行各段信息，在BBBC表建立第一列‘LV NAME’為字段名，第二列‘LPs’為字段名，第三列‘PPs’為字段名，后面類似
從第三行開始作為數(shù)據(jù)寫入BBBC表
|
免費(fèi)注冊
發(fā)表于 2015-08-04 14:49
發(fā)表于 2015-08-07 16:15