Replicated mqt - nodenumber() function

FAQ

Profile

Replicated mqt - nodenumber() function

Database Help (Home) -> DB2

Next: Could not find stored procedure

Author

Message

Arun Srinivasan

External

Since: Feb 05, 2008
Posts: 29

(Msg. 1) Posted: Wed Dec 10, 2008 5:50 pm Post subject: Replicated mqt - nodenumber() function Archived from groups: comp>databases>ibm-db2 (more info?)

I have a table arun.temp1 that is defined in one node tablespace, andarun.temp1_mqt that is defined with 'replicated' in a multi node tablespace. Now since the mqt is replicated, is there a definite way of checking whether all rows are available in all nodes? I tried doing a nodenumber (), but got SQL0391N * The function cannot be used on rows from a replicated materialized query table. Is there a definite way of finding this? Please help. >> Stay informed about: Replicated mqt - nodenumber() function

Display posts from previous:

Related Topics:

SQL/400 and "TOP x" function - I have a join out left that I need the TOP x functionality for, but it appears not to be supported on the iSeries at least not in Version 5.1 Any ideas on getting around it, without using a RRN (The secondary file we need it for has almost 100 million..

TRANSLATE function - Hello All, I am trying something so simple, I have no idea why it doesn't work! create table test1 (c1 VARCHAR(16)); insert into test1 values( '12154846' ); select translate(c1, '5', 'A') from test1; You'd think I would get a modified version of the..

TRANSLATE function - Hi, Does anybody know why i get this error: SQL0176N The second, third or fourth argument of the TRANSLATE scalar function is incorrect. SQLSTATE=42815 with this query: SELECT TRANSLATE(p.meno,..

Problem with MONTH() function - I have a query that runs perfectly when doing a date equal comparison (see last line in the subquery: AND T2.DQ_DAT = '14.02.2005'). A direct comparison of the date is not sufficient for my needs, so I tried to convert the date using the MONTH()..

Knut's function "elelments" - Need help with Knut's function for summing values in rows here is my example: WITH T1 (C1) AS (VALUES ('1'), ('1.1'), ('1.2.1.2'), ('1.10.1'), ('1.10.1.2.2'), ('1.22.99.1'), ('1.2'), ('1.3.3.7.4'), ...

	Database Help (Home) -> DB2	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum