Archive for the ‘system admin’ Category

DB2 V9.1 on AIX: tips on drop instance, de_install, re_install, re-create instance

Thursday, June 14th, 2007

Like the Nissan Pathfinder's ad: "not that you would, but you could". In certain performance test conditions, you may have to drop the current DB2 V8 instance, install V9.1, and re-create a instance. Here is a short list of helpful commands - run as root unless specifically sudo'ed: 1. Drop ...

tar only directories, not files

Thursday, June 14th, 2007

Sometimes you want to preserve only a directory structure into a tar ball without having to archive the files themselves. This can happen if you want to backup a pre-defined directory structure, run some tests, and do not really care about the files created during the test. You ...

Increase storage for existing LV

Sunday, June 3rd, 2007

Steps taken to to increase the storage for an existing logical volume. The following commands are for AIX. The steps, however, are universal. You only need to substitute the commands for other platforms. 1) How big is the vg? <Oracle 10.2.0.2 - ora10g>/home/oracle $ lsvg oradata_vg VOLUME GROUP: ...