2006-03-21

errclear after VIOS reboot

I have LPARs with rootvg mirrored across two VIO servers (client LVM mirroring). If one VIOS is rebooted, several errors will get logged in the errpt on the client LPARs (LVM I/O error, PV declared missing, etc). To clear these errors in one shot while preserving other unrelated errors in the errpt, run this command on each client LPAR:

errclear -j DE3B8540,EAA3D429,F7DDA124,41BF2110,613E5F38,E86653C3,52715FA5,AA8AB241,857033C6 0

Labels:

2006-03-10

DB2 tablespace usage query

select cast(tablespace_name as varchar(10)),page_size,usable_pages,used_pages from table (snapshot_tbs_cfg('dbname',-1)) as x where tablespace_type=0

tablespace_type=0 means DMS (Database Managed Space) tablespace. For SMS (System Managed Space) tablespaces, useable_pages always equals used_pages. Substitute dbname with the name of the database.

Labels: