Prev: DB2 UDB V9.5 Lock wait event capability?
Next: knowing if an NLI is active or has occurred recently
From: Bruce on 20 Apr 2010 14:49
On Apr 20, 1:33 pm, "Mark A" <no...(a)nowhere.com> wrote:
> "Bruce" <bwmille...(a)gmail.com> wrote in message
>
> news:ae7155e6-6ce7-49b0-9ccb-f4a5f441748e(a)22g2000vbg.googlegroups.com...
>
> > Hi all -
>
> > Running AIX 6, UDB 9.1.4.
>
> > Other than referring to the db2inst1.nfy log is there anyway to know
> > if a table has been created with 'not logged initially'?   I need
> > something that I can query to determine the NLI status.
>
> > Thanks,
>
> > Bruce
>
> Did you try db2look? You can pull DDL for one table with -t option

That's an idea...but is it going to tell me what's been NLI-activated
in the last...say...2 days? I need to know when and if I miss
the .nfy msg and if my HADR standby is still good.
 | 
Pages: 1
Prev: DB2 UDB V9.5 Lock wait event capability?
Next: knowing if an NLI is active or has occurred recently