Prev: Change column Data Type from Integer to Decimal
Next: problem starting db with version 9.1
From: Lennart on 17 Dec 2006 03:36

Lennart wrote:
[...]
>
> I noticed you post and the idea looks interesting, however I only get
> null for STMT_TEXT in SNAPSHOT_STATEMENT. What does it take to get a
> value there? I switched on monitors as:
>
> db2 update monitor switches using statement on BUFFERPOOL on LOCK on
> SORT on TABLE on UOW on
>
> But I still dont get any value. Any ideas, anyone?
>

Updating the dbm cfg seem to help :-)


> BTW, all snapshot functions take <dbname> as an argument. Is there a
> current_database register or such that can be used instead of an actual
> name?
>

CURRENT_SERVER seem ok for the moment


/Lennart

First  |  Prev  | 
Pages: 1 2
Prev: Change column Data Type from Integer to Decimal
Next: problem starting db with version 9.1