By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,011 Members | 1,000 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,011 IT Pros & Developers. It's quick & easy.

Timestamps on data records, Documentation on old versions of DB2

P: n/a
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
Jul 2 '08 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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/infoce...v5r4/index.jsp

[2]
http://publib.boulder.ibm.com/infoce...i5os/index.jsp

[3] http://www-304.ibm.com/systems/suppo...ums/index.html

[4]
http://www-306.ibm.com/software/data...on/edition_i.h
tml
Cheers,

Dave.
Jul 3 '08 #2

P: n/a
Dave Hughes wrote:
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).
<snip>
>
> 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/infoce...v5r4/index.jsp

[2]
http://publib.boulder.ibm.com/infoce...i5os/index.jsp

[3] http://www-304.ibm.com/systems/suppo...ums/index.html

[4]
http://www-306.ibm.com/software/data...on/edition_i.h
tml
This is probably a long shot, but if the client tables are journaled (eg
for commitment control), there may be a way to use journal APIs along
with the data captured in journals to determine "new" data since it was
last published. I mention this because it might provide a means to
either determine which rows have changed (to formulate SQL queries), or
perhaps the new data could be extracted from journal entries, without
actually changing table definitions.

http://publib.boulder.ibm.com/infoce...kiconcepts.htm
http://publib.boulder.ibm.com/infoce...=/apis/jc1.htm

Fyi - another newsgroup where many System i (aka iSeries, AS/400)
experts contribute is: comp.sys.ibm.as400.misc
You might ask for ideas there as well.

--
Karl Hanson
Jul 3 '08 #3

P: n/a
Thanks, Dave & Karl.
Jul 10 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.