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 3 2452
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.db 2.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.
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.as 400.misc
You might ask for ideas there as well.
--
Karl Hanson This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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? If the timestamps
measure visits to a web site, how to easily say there were 45 visits on
January 4th?
The first idea that occurs to me is to put them all in an array and
then loop through the array and use date() on each, one at a time,...
|
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 2Mb)
are stored in BLOB column.
The amount of documents for the first year should not exceed 5/6 Giga,
but I cannot make prevision for the next years.
Those documents are mainly just accessed (update and delete are not so
|
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 storing the timestamps
for each grid row? is it possible to hold them in the grid in someway? or do
i need to look at other means
ive only used Oracle Timestamps before and they where just decimal
timestamps which made it easy!! could just store them...
|
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 with 512Mb of ram and swap. This was just
upgraded from 7.4 (just to make sure I'm current). Some of my settings in
postgresql are giving fatal errors but I don't think my issue is related to my
query problems. I also have a laptop running with...
|
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 per line (this is
in order to make the process of adding new IDs easy, since it's only
done at time of configuration).
I have no problem with retrieving the contents of the textBox,
splitting it into a string array, validating the individual...
| |
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 hour:minute:second as of the corresponding old day.
The only routine for this job seems to be
localtime(timestmap) - this is Windows Vista,
Visual Studio 2005 C++.
|
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 how...
|
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 timeStamps without
iterating over a list. My thought was to use a binary tree, am i
overthinking the problem to try and implement this structure inside of
python? I was also hoping this would already be done for me.
Regards,
|
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 date i.e 1/1/08 and 31/1/08, the field name is Transaction Date and some dates have timestamps and some dont.
Parameter >= And <=
When entering the last date the query, if the transaction date record has a time stamp of 31/1/08 10:23 this is not...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |