DB2表空间管理及查看脚本(SHELL)等(国外英语资料).docVIP

DB2表空间管理及查看脚本(SHELL)等(国外英语资料) Task management: 1. Sh file #! / bin/sh The # tablespace management job, please do not delete, the operating system has been called normally # call time, 17:00 every day # crontab - e opens, editable / home/db2app /.profile The # script deletes the table that is created at 22 days or the total number greater than 400 * 0.5, ensuring that the amount of data cannot be greater than 50% of the total space and the creation date cannot be greater than 22 days Db2 connect to esopdb; Res = tbopres. TXT SQL = With a as ( The select Rownumber () over (order by npages desc) as od, DB2INFO. | | tabname, Decimal (sum (npages) * 1.00 * 32768 / (1024 * 1024 * 1024), 4, 2) GUSAGE, Create_time ct The from syscat.tables tables Where tbspace = TBS_DW_USER and type = T And OWNER = DB2APP and TABSCHEMA = DB2INFO The and ( The tabname not like DIM % and tabname not like % LOG % and tabname not like % and tabname not like % And tabname not like % and tabname not like % ) Group by tabname, npages has, create_time The order by GUSAGE desc ), B the as ( Select a_s. od, a_s. tabname, a_s. gusage, Case a_s. Od 1 then the when a_s gusage (a) from a as a_d. A_s. Ct From the as a a_s The order by a_s. Od ) Select cast ( alter table | |, |, | | | activate not logged with empty table; drop table ) | | b. t abname | | replace (; - od: | | cast (b.o. d as char (3)) | |, gusage: | | cast (b.g usage as char (10), total: | | cast (b.t as decimal (5, 2)) as char (10)) | | , percent: | | cast (cast (b.t. ot / 400 as decimal (5, 2)) as char (10) | | , created before | | cast (days (current_date) - days (ct) as char (2)) | | days | -, , 00, 0.) as varchar (300)) as SQL The from b Where b.t ot = 400 * 0.5 or days (current_date) -days (ct) = 22 Order by b.o. d, days (current_date) -days (b.c t) desc # execution does not have the content of the title class Db2 - x $SQL $res Branch # and read each line Tr ; \ n ${res} | while read line The do Echo ` date + % % m Y H: % d % %