473,326 Members | 2,023 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Timestamps on data records, Documentation on old versions of DB2

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
3 2434
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
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
Thanks, Dave & Karl.
Jul 10 '08 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: lkrubner | last post by:
This might be an idiot question, but how do you group by timestamps by date? I mean, given a large number of timestamps, spanning many months, how do grab them and say how many are from each day?...
3
by: hamvil79 | last post by:
I'm implementig a java web application using MySQL as database. The main function of the application is basically to redistribuite documents. Those documents (PDF, DOC with an average size around...
4
by: Craig G | last post by:
im not too sure how i should be storing the SQL2000 timestamps basically i return a dataset which is used to populate an editable grid. this dataset contains the timestamp. how should i be...
2
by: Keith C. Perry | last post by:
Ok, I've tried a number of things here and I know I'm missing something but at this point my head is spinning (i.e. lack of sleep, too much coffee, etc...) My environment is PG 7.4.3 on Linux...
0
by: EricLondaits | last post by:
Hi, I have an ASP.NET page with a ListBox that is data bound to a table with a single field (it holds a list of valid IDs). The page also has a textBox into which you can add new valid IDs, one...
16
by: maruk2 | last post by:
I have some old data files with old timestamps, where timestmap=time(NULL), some of them date back to the year 1999. I want to my code to print the timestamps and each one to include...
2
by: markstraathof | last post by:
Hi there, Does anybody know how to use timestamps in Microsof Access? I want to use it for updating records, without overwriting excisting data. I was told that this is possible but I don't know...
6
by: xkenneth | last post by:
All, Just a quick question. I want to be able to have a data structure that organizes data (timestamps I'm working with) sequentially, so that i can easily retrieve the first x amount of...
2
by: Kerryn | last post by:
Hi all new to this site so looking for some help. I am working in Access 2002, using a select query. I am trying to use a date range parameter to allow the users to end the start date and end...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.