Hi,
as we do some CBF settings on any customer's DBMS server, I have written
a batch file that works fine on Windows machines:
iisetres ii.%computername%.dbms.*.max_tuple_length 0
iisetres ii.%computername%.dbms.*.cursor_limit 36
iisetres ii.%computername%.dbms.*.vch_compression OFF
iisetres ii.%computername%.dbms.*.stack_size 131072
iisetres ii.%computername%.dbms.*.default_page_size 4096
iisetres ii.%computername%.dbms.*.system_maxlocks 500
iisetres ii.%computername%.dbms.*.opf_memory 10000000
iisetres ii.%computername%.dbms.*.qsf_memory 4100000
iisetres ii.%computername%.dbms.*.psf_memory 6000000
iisetres ii.%computername%.dbms.private.*.cache.p4k_status ON
iisetres ii.%computername%.dbms.private.*.cache.p8k_status ON
iisetres ii.%computername%.dbms.private.*.cache.p16k_status ON
iisetres ii.%computername%.dbms.private.*.cache.p32k_status ON
iisetres ii.%computername%.dbms.private.*.cache.p64k_status ON
iisetres ii.%computername%.dbms.private.*.dmf_cache_size 2560
iisetres ii.%computername%.dbms.private.*.p4k.dmf_cache_size 2560
iisetres ii.%computername%.rcp.lock.per_tx_limit 4803
iisetres ii.%computername%.gcc.*.inbound_limit 512
iisetres ii.%computername%.gcc.*.outbound_limit 512
I wonder if there is an equivalent to %computername% for the Linux bash?
Any ideas?
Regards
Gerhard
Betty & Karl Schendel - 26 Sep 2006 15:27 GMT
>Hi,
>
[quoted text clipped - 3 lines]
>iisetres ii.%computername%.dbms.*.max_tuple_length 0
>iisetres ii.%computername%.dbms.*.cursor_limit 36
[snip]
>I wonder if there is an equivalent to %computername% for the Linux
>bash? Any ideas?
I think you want:
iisetres ii.`iipmhost`.blah blah
By the way, on Unix don't forget to quote or escape the *, or the
shell will try to expand it as filenames. I'd suggest something like
this if you have more than a couple iisetres lines:
pmhost=`iipmhost`
iisetres ii.$pmhost.dbms.\*.cursor_limit 36
etc
Karl
William Avery - 26 Sep 2006 15:29 GMT
Gerhard Hofmann said the following on 26/09/06 15:04:
<snip>
I wonder if there is an equivalent to %computername% for the Linux
bash? Any ideas?
`hostname`
Will