Good work Steve, thanks for passing this on.
Also note that 12GB is not enough virtual memory to run a library
manager
with minimal configuration.
I have 8GB of real and 4GB of swap on this zone and am running out
of swap
space.
Crikey, I guess the days of running a couple of TSM Server instances
as VMs on my laptop to test, learn and demo stuff to customers are
well and truly over with 6.x - shame.
Cheers,
//David McClelland
London
On 17 Jun 2010, at 01:25, Steve Harris <st...@stevenharris.info> wrote:
Hi All
I'm just dropping this note here for the next fellow that comes along.
Installing TSM 6.2.0.0 Server on Solaris 10 X86_64 (AMD)
I went to TSM support to find out which filesystem to use for the DB
since
there are two free choices and UFS is a known poor performer.
Previously we
have always used raw volumes. They advised that either was
supported and
that anything more than that would have to be taken up as a
consulting job.
So, I decided to go with ZFS.
It turns out that DB2 expects to be able to do direct IO, but ZFS
does not
support that. This caused errors when writing to the DB
The fix is to change the FS_CACHING parameter on the tablespaces as
follows
Become the instance owner
connect to database
query catalog to get FS_CACHING setting
Change all FS_CACHING=1 to 0
restart TSM
my log ....
bash-3.00$ id
uid=205(tsminst1) gid=200(tsm)
bash-3.00$ db2 connect to tsmdb1
Database Connection Information
Database server = DB2/SUNX8664 9.7.1
SQL authorization ID = TSMINST1
Local database alias = TSMDB1
bash-3.00$ db2 "SELECT substr(TBSP_NAME,1,40) as TBSP_NAME, TBSP_TYPE,
TBSP_CONTENT_TYPE, FS_CACHING FROM TABLE(SNAP_GET_TBSP(CAST(NULL AS
VARCHAR(1)),-1)) AS T" | tee sel.txt
TBSP_NAME TBSP_TYPE TBSP_CONTENT_TYPE
FS_CACHING
---------------------------------------- --------- -----------------
----------
SYSCATSPACE 0 0
1
TEMPSPACE1 1 2
0
USERSPACE1 0 1
1
TSMTEMP 1 3
0
IDXSPACE1 0 1
1
LARGESPACE1 0 1
1
LARGEIDXSPACE1 0 1
1
LGTMPTSP 1 2
0
SYSTOOLSPACE 0 1
1
SYSTOOLSTMPSPACE 1 3
0
10 record(s) selected.
bash-3.00$ awk '$4==1 {print "db2 alter tablespace",$1,"file system
caching"}' sel.txt | tee alter_tbs.sh
db2 alter tablespace SYSCATSPACE file system caching
db2 alter tablespace USERSPACE1 file system caching
db2 alter tablespace IDXSPACE1 file system caching
db2 alter tablespace LARGESPACE1 file system caching
db2 alter tablespace LARGEIDXSPACE1 file system caching
db2 alter tablespace SYSTOOLSPACE file system caching
bash-3.00$ . alter_tbs.sh
DB20000I The SQL command completed successfully.
DB20000I The SQL command completed successfully.
DB20000I The SQL command completed successfully.
DB20000I The SQL command completed successfully.
DB20000I The SQL command completed successfully.
DB20000I The SQL command completed successfully.
bash-3.00$ db2 "SELECT substr(TBSP_NAME,1,40) as TBSP_NAME, TBSP_TYPE,
TBSP_CONTENT_TYPE, FS_CACHING FROM TABLE(SNAP_GET_TBSP(CAST(NULL AS
VARCHAR(1)),-1)) AS T"
TBSP_NAME TBSP_TYPE TBSP_CONTENT_TYPE
FS_CACHING
---------------------------------------- --------- -----------------
----------
SYSCATSPACE 0 0
0
TEMPSPACE1 1 2
0
USERSPACE1 0 1
0
TSMTEMP 1 3
0
IDXSPACE1 0 1
0
LARGESPACE1 0 1
0
LARGEIDXSPACE1 0 1
0
LGTMPTSP 1 2
0
SYSTOOLSPACE 0 1
0
SYSTOOLSTMPSPACE 1 3
0
Also note that 12GB is not enough virtual memory to run a library
manager
with minimal configuration.
I have 8GB of real and 4GB of swap on this zone and am running out
of swap
space.
I have another zone with the library client instance. It has a lot of
definitions but only two real clients, both user workstations. it is
using
16GB of real and 42% of its 16GB of swap.
The old rule of thumb swap=2xreal may apply here.
Regards
Steve.
Steven Harris
TSM Admin,
Paraparaumu New Zealand
