 | |
knowing if an NLI is active or has occurred recently
comp.databases.ibm-db2 comp.databases.ibm-db2
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: knowing if an NLI is active or has occurred recently -
04-22-2010
, 10:25 AM
|
On Apr 21, 7:47*pm, "Mark A" <no... (AT) nowhere (DOT) com> wrote: "The Boss" <use... (AT) No (DOT) Spam.Please.invalid> wrote in message news:4bcf7ed0$0$4570$e4fe514c (AT) dreader30 (DOT) news.xs4all.nl... It doesn't, and you shouldn't use NLI in a HADR environment. Please read my previous reply I posted about 24 hours ago. -- Jeroen Bruce understands that one should not use it an HADR environment, but he needs to check to see if someone else did it. Right...HADR has literally saved our B**T many times and we absolutely positively need it...Do I wish that PeopleSoft didn't use NLI? *Sure, but it does and there isn't a way around it. *So, I'm stuck with what I've been given. *Now, back to the question: "How can I know from looking at something in DB2 if HADR has been compromised from an NLI- standpoint?". |
descriptors. The NLI-attribute of a table is present there and the
packed descriptor can be dumped using db2cat. I understand you are
looking for something that you could query, but I am not aware of any.
db2 "CREATE TABLE PARTTABNLI (ID INT, ALPHA VARCHAR(20)) PARTITION BY
RANGE (ID) (STARTING FROM (1) ENDING AT (150) EVERY(10) , STARTING
FROM (200) ENDING AT (250) EVERY (10)) NOT LOGGED INITIALLY"
db2cat -db eee -n PARTTABNLI -s NARESH -t | grep "Table not logged"
Table not logged : 1
The 'Table not logged' field is set to 0, if NLI attribute is not
specified during table creation.
Perhaps this could serve as your alternative mechanism to validate
whether any table is created as NLI. You should be able to automate
this by querying the database for all tables of interest and invoking
db2cat.
Naresh
#12
| |||
| |||
|
|
On Apr 22, 5:35*am, Bruce <bwmille... (AT) gmail (DOT) com> wrote: On Apr 21, 7:47*pm, "Mark A" <no... (AT) nowhere (DOT) com> wrote: "The Boss" <use... (AT) No (DOT) Spam.Please.invalid> wrote in message news:4bcf7ed0$0$4570$e4fe514c (AT) dreader30 (DOT) news.xs4all.nl... It doesn't, and you shouldn't use NLI in a HADR environment. Please read my previous reply I posted about 24 hours ago. -- Jeroen Bruce understands that one should not use it an HADR environment, buthe needs to check to see if someone else did it. Right...HADR has literally saved our B**T many times and we absolutely positively need it...Do I wish that PeopleSoft didn't use NLI? *Sure, but it does and there isn't a way around it. *So, I'm stuck with what I've been given. *Now, back to the question: "How can I know from looking at something in DB2 if HADR has been compromised from an NLI- standpoint?". Among other places, DB2 stores table information in packed descriptors. The NLI-attribute of a table is present there and the packed descriptor can be dumped using db2cat. I understand you are looking for something that you could query, but I am not aware of any. db2 "CREATE TABLE PARTTABNLI (ID INT, ALPHA VARCHAR(20)) PARTITION BY RANGE (ID) (STARTING FROM (1) ENDING AT (150) EVERY(10) , STARTING FROM (200) ENDING AT (250) EVERY (10)) NOT LOGGED INITIALLY" db2cat -db eee -n PARTTABNLI -s NARESH -t | grep *"Table not logged" *Table not logged * * * * *: 1 The 'Table not logged' field is set to 0, if NLI attribute is not specified during table creation. Perhaps this could serve as your alternative mechanism to validate whether any table is created as NLI. You should be able to automate this by querying the database for all tables of interest and invoking db2cat. Naresh |
much appreciated!
-Bruce
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.