SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 03:29 AM
| ||||
| ||||
 Snaphot_table function gives unexpected result I have db2 8.1.5 (EE) on Windows 2003 Server I have all monitor switches on When I do : dbn2 get snapshot for tables on dbname I get the expected output When I do db2 select * from table(snapshot_table('dbname',-1)) as x I get sql0443 with diagnostic text sql1611 (no data) Is this a bug or am I doing something wrong? Thanks      |
|
02-27-2008, 03:29 AM
| |||
| |||
| Re: Snaphot_table function gives unexpected result JS wrote: > I have db2 8.1.5 (EE) on Windows 2003 Server > I have all monitor switches on > When I do : > dbn2 get snapshot for tables on dbname I get the expected output > > When I do > db2 select * from table(snapshot_table('dbname',-1)) as x I get > sql0443 with diagnostic text sql1611 (no data) > > Is this a bug or am I doing something wrong? > Thanks How did you turn on teh switches? Use: UPDATE DBM CFG USING switchName ON -- Serge Rielau DB2 SQL Compiler Development IBM Toronto Lab |
|
02-27-2008, 03:29 AM
| |||
| |||
| Re: Snaphot_table function gives unexpected result Serge Rielau <srielau@ca.ibm.com> wrote in message news:<3cihabF6lfif9U1@individual.net>... > JS wrote: > > I have db2 8.1.5 (EE) on Windows 2003 Server > > I have all monitor switches on > > When I do : > > dbn2 get snapshot for tables on dbname I get the expected output > > > > When I do > > db2 select * from table(snapshot_table('dbname',-1)) as x I get > > sql0443 with diagnostic text sql1611 (no data) > > > > Is this a bug or am I doing something wrong? > > Thanks > How did you turn on teh switches? > Use: > UPDATE DBM CFG USING switchName ON Ok, thank you, now it works, that leads me to ask: why does UPDATE DBM CFG USING DFT_MON_TABLE ON work and db2 update monitor swithces using table on not work? If I update the monitor switch for the bufferpools with the update monitor switch command, for example, the snapshot will return the data, however table data needs the monitor switch turned on at the instance level in order to work? |
|
02-27-2008, 03:30 AM
| ||||
| ||||
| Re: Snaphot_table function gives unexpected result JS wrote: > Serge Rielau <srielau@ca.ibm.com> wrote in message news:<3cihabF6lfif9U1@individual.net>... > >>JS wrote: >> >>>I have db2 8.1.5 (EE) on Windows 2003 Server >>>I have all monitor switches on >>>When I do : >>>dbn2 get snapshot for tables on dbname I get the expected output >>> >>>When I do >>>db2 select * from table(snapshot_table('dbname',-1)) as x I get >>>sql0443 with diagnostic text sql1611 (no data) >>> >>>Is this a bug or am I doing something wrong? >>>Thanks >> >>How did you turn on teh switches? >>Use: >>UPDATE DBM CFG USING switchName ON > > > Ok, thank you, now it works, that leads me to ask: > why does UPDATE DBM CFG USING DFT_MON_TABLE ON work and > db2 update monitor swithces using table on not work? > If I update the monitor switch for the bufferpools with the update > monitor switch command, for example, the snapshot will return the > data, however table data needs the monitor switch turned on at the > instance level in order to work? It has been quoted as a "temporary known limitation" to me. T'is all I know.... Cheers Serge -- Serge Rielau DB2 SQL Compiler Development IBM Toronto Lab |
Linear Mode
