Prev: privileges on functions
Next: SQL0101N The statement is too long or too complex. SQLSTATE=54001
From: Ion Freeman on 2 Jul 2008 15:27
Hi!
My database work has been largely with SQL Server, PostgreSQL and
Oracle, so when I have a DB2 question, I don't really know where to
turn. I could find the documentation for the current version of DB2 on
IBM's website, but I don't know if what's true for the current version
is true for the version my client has. Can someone point me to older
docs?

The question is simply this:
1. There are a number of tables on a DB2 database
2. The client pushes this data out to our data store
3. We'd like to know if there is some way for them to only publish the
data that's been added, updated or deleted since the last time they
published.

Now, they're not going to change the tables, and we don't want to ask
a lot of their DBAs. Does DB2 always supply this functionality?

I'm working on finding out what version of DB2 they have, but it's on
AS/400. Does this exclude DataPropagator as a solution?

Thanks!

Ion
From: Dave Hughes on 2 Jul 2008 21:09
Ion Freeman wrote:

> Hi!
> My database work has been largely with SQL Server, PostgreSQL and
> Oracle, so when I have a DB2 question, I don't really know where to
> turn. I could find the documentation for the current version of DB2 on
> IBM's website, but I don't know if what's true for the current version
> is true for the version my client has. Can someone point me to older
> docs?

Sure - as you're dealing with DB2 for AS/400 (aka iSeries), you'll need
the i5/OS InfoCenter (which documents everything about i5/OS, including
the integrated DB2 database).

For the i5/OS v5r4 InfoCenter [1] select "i5/OS Information Center..."
on the left, and then expand the "Database" entry for DB2 information.

For the i5/OS v6r1 InfoCenter [2], just expand the "Database" entry on
the left (the first node, "i5/OS Information", should open
automatically).

For DB2 for i5/OS specific support, there's also an
ibm.software.db2.os400 newsgroup available on some news servers, and
several forums [3].

> The question is simply this:
> 1. There are a number of tables on a DB2 database
> 2. The client pushes this data out to our data store
> 3. We'd like to know if there is some way for them to only publish the
> data that's been added, updated or deleted since the last time they
> published.
>
> Now, they're not going to change the tables, and we don't want to ask
> a lot of their DBAs. Does DB2 always supply this functionality?

Not on any edition I know of - you'd need some column indicating the
last modification timestamp of a row to know whether it'd changed since
the last time you checked it.

Certainly on DB2 for Linux/UNIX/Windows, tables don't include such a
column by default. While I'm less familiar with DB2 for z/OS and DB2
for i5/OS, I don't believe they include such a column by default either.

> I'm working on finding out what version of DB2 they have, but it's on
> AS/400. Does this exclude DataPropagator as a solution?

I'm not familiar with DataPropogator, so I can't say whether it'll do
what you want, but according to [4] it does appear to be available for
iSeries.

[1] http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp

[2]
http://publib.boulder.ibm.com/infocenter/systems/scope/i5os/index.jsp

[3] http://www-304.ibm.com/systems/support/i/forums/index.html

[4]
http://www-306.ibm.com/software/data/integration/replication/edition_i.h
tml


Cheers,

Dave.
From: Ion Freeman on 10 Jul 2008 16:57
Thanks, Dave & Karl.
 | 
Pages: 1
Prev: privileges on functions
Next: SQL0101N The statement is too long or too complex. SQLSTATE=54001