473,324 Members | 2,567 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,324 software developers and data experts.

Accuracy of Data in /DDEL of db2dart

Hi Everyone,

I am using db2dart to dump some sample table data in delimited format,
but I am finding inconsistencies between the actual data in database
table and the records dumped in .del file.

db2dart sample /ddel

Table object data formatting start.
Please enter
Table ID or name, tablespace ID, first page, num of pages:
(suffic page number with 'p' for pool relative)
DB2INST1.EMPLOYEE,2,0,1000

14 of 14 columns in the table will be dumped.
Column numbers and datatypes of the columns dumped:
0 CHAR() -FIXED LENGTH CHARACTER STRING
1 VARCHAR() -VARIABLE LENGTH CHARACTER STRING
2 CHAR() -FIXED LENGTH CHARACTER STRING
3 VARCHAR() -VARIABLE LENGTH CHARACTER STRING
4 CHAR() -FIXED LENGTH CHARACTER STRING
5 CHAR() -FIXED LENGTH CHARACTER STRING
6 DATE
7 CHAR() -FIXED LENGTH CHARACTER STRING
8 SMALLINT
9 CHAR() -FIXED LENGTH CHARACTER STRING
10 DATE
11 DECIMAL
12 DECIMAL
13 DECIMAL
Default filename for output data file is TS2T5.DEL,
do you wish to change filename used? y/n
Filename used for output data file is TS2T5.DEL. If existing file,
data will be appended to it.

Formatted data being dumped ...
Dumping Page 0 ....
Dumping Page 1 ....
Table object data formatting end.

______________________________________

The requested DB2DART processing has completed successfully!
All operation completed without error;
no problems were detected in the database.
______________________________________

Complete DB2DART report found in: SAMPLE.RPT

_______ D A R T P R O C E S S I N G C O M P L E T E
_______


some of the rows which are not maching in the dumped .del file

"000130","DOLORES","M","QUINTANA","C01","4578",197 10728,"ANALYST
",16,"F",19250915,+0023-00.00,+0000500.00,+0001-04.00

000130 DOLORES M QUINTANA C01 4578
07/28/1971 ANALYST 16 F 09/15/1925 23800.00 500.00
1904.00

"000020","MICHAEL","L","THOMPSON","B01","3476",197 31010,"MANAGER
",18,"M",19480202,+0041250.00,+0000-00.00,+0003300.00

000020 MICHAEL L THOMPSON B01 3476
10/10/1973 MANAGER 18 M 02/02/1948 41250.00 800.00
3300.00

"000340","JASON","R","GOUNOT","E21","5698",1947050 5,"FIELDREP",16,"M",19260517,+0023-40.00,+0000500.00,+0001-07.00

000340 JASON R GOUNOT E21 5698
05/05/1947 FIELDREP 16 M 05/17/1926 23840.00 500.00
1907.00



I have noticed that the values in the last 3 columns of the dumped
..del file data are not matching the same in the actual tables from the
database. the dashes (-) represent either digit 8 or digit 9.

any idea why this is happening? I use Redhat 7.3 UDB 7.2 Fixpack 5.
This is a sample database.

thanks in advance,
dotyet
Nov 12 '05 #1
2 3682
My first guess would be to install the most current fixpack and see if
that helps. I then checked the IBM UDB LUW support site
http://www.ibm.com/software/data/db2/udb/support/
and found that the fixpack 13 is the current one.

Examining the APAR list for fixpack 13 and searching for "db2dart"
located the following APAR in fixpack 8:
IY31958 DB2DART /DDEL DOES NOT DUMP OUT DECIMAL COLUMN VALUES
CORRECTLY.

I returned to the support page and searched on the APAR and was led to
the following information about the APAR:

Error description

db2dart /ddel does not dump out the decimal column values
correctly - some numeric values will be replaced by '-'.
Your problem was fixed some time ago. My initial guess about fixing it
hit the nail on the head.
Philip Sherman

dotyet wrote:
Hi Everyone,

I am using db2dart to dump some sample table data in delimited format,
but I am finding inconsistencies between the actual data in database
table and the records dumped in .del file.

db2dart sample /ddel

Table object data formatting start.
Please enter
Table ID or name, tablespace ID, first page, num of pages:
(suffic page number with 'p' for pool relative)
DB2INST1.EMPLOYEE,2,0,1000

14 of 14 columns in the table will be dumped.
Column numbers and datatypes of the columns dumped:
0 CHAR() -FIXED LENGTH CHARACTER STRING
1 VARCHAR() -VARIABLE LENGTH CHARACTER STRING
2 CHAR() -FIXED LENGTH CHARACTER STRING
3 VARCHAR() -VARIABLE LENGTH CHARACTER STRING
4 CHAR() -FIXED LENGTH CHARACTER STRING
5 CHAR() -FIXED LENGTH CHARACTER STRING
6 DATE
7 CHAR() -FIXED LENGTH CHARACTER STRING
8 SMALLINT
9 CHAR() -FIXED LENGTH CHARACTER STRING
10 DATE
11 DECIMAL
12 DECIMAL
13 DECIMAL
Default filename for output data file is TS2T5.DEL,
do you wish to change filename used? y/n
Filename used for output data file is TS2T5.DEL. If existing file,
data will be appended to it.

Formatted data being dumped ...
Dumping Page 0 ....
Dumping Page 1 ....
Table object data formatting end.

______________________________________

The requested DB2DART processing has completed successfully!
All operation completed without error;
no problems were detected in the database.
______________________________________

Complete DB2DART report found in: SAMPLE.RPT

_______ D A R T P R O C E S S I N G C O M P L E T E
_______


some of the rows which are not maching in the dumped .del file

"000130","DOLORES","M","QUINTANA","C01","4578",197 10728,"ANALYST
",16,"F",19250915,+0023-00.00,+0000500.00,+0001-04.00

000130 DOLORES M QUINTANA C01 4578
07/28/1971 ANALYST 16 F 09/15/1925 23800.00 500.00
1904.00

"000020","MICHAEL","L","THOMPSON","B01","3476",197 31010,"MANAGER
",18,"M",19480202,+0041250.00,+0000-00.00,+0003300.00

000020 MICHAEL L THOMPSON B01 3476
10/10/1973 MANAGER 18 M 02/02/1948 41250.00 800.00
3300.00

"000340","JASON","R","GOUNOT","E21","5698",1947050 5,"FIELDREP",16,"M",19260517,+0023-40.00,+0000500.00,+0001-07.00

000340 JASON R GOUNOT E21 5698
05/05/1947 FIELDREP 16 M 05/17/1926 23840.00 500.00
1907.00


I have noticed that the values in the last 3 columns of the dumped
.del file data are not matching the same in the actual tables from the
database. the dashes (-) represent either digit 8 or digit 9.

any idea why this is happening? I use Redhat 7.3 UDB 7.2 Fixpack 5.
This is a sample database.

thanks in advance,
dotyet


Nov 12 '05 #2
Hi Philip,

Thanks a lot for the help, both for this one and the one on Database Design Basics.

bye,
dotyet

Philip Sherman <ps******@ameritech.net> wrote in message news:<%S****************@newssvr16.news.prodigy.co m>...
My first guess would be to install the most current fixpack and see if
that helps. I then checked the IBM UDB LUW support site
http://www.ibm.com/software/data/db2/udb/support/
and found that the fixpack 13 is the current one.

Examining the APAR list for fixpack 13 and searching for "db2dart"
located the following APAR in fixpack 8:
IY31958 DB2DART /DDEL DOES NOT DUMP OUT DECIMAL COLUMN VALUES
CORRECTLY.

I returned to the support page and searched on the APAR and was led to
the following information about the APAR:

Error description

db2dart /ddel does not dump out the decimal column values
correctly - some numeric values will be replaced by '-'.
Your problem was fixed some time ago. My initial guess about fixing it
hit the nail on the head.
Philip Sherman

dotyet wrote:
Hi Everyone,

I am using db2dart to dump some sample table data in delimited format,
but I am finding inconsistencies between the actual data in database
table and the records dumped in .del file.

db2dart sample /ddel

Table object data formatting start.
Please enter
Table ID or name, tablespace ID, first page, num of pages:
(suffic page number with 'p' for pool relative)
DB2INST1.EMPLOYEE,2,0,1000

14 of 14 columns in the table will be dumped.
Column numbers and datatypes of the columns dumped:
0 CHAR() -FIXED LENGTH CHARACTER STRING
1 VARCHAR() -VARIABLE LENGTH CHARACTER STRING
2 CHAR() -FIXED LENGTH CHARACTER STRING
3 VARCHAR() -VARIABLE LENGTH CHARACTER STRING
4 CHAR() -FIXED LENGTH CHARACTER STRING
5 CHAR() -FIXED LENGTH CHARACTER STRING
6 DATE
7 CHAR() -FIXED LENGTH CHARACTER STRING
8 SMALLINT
9 CHAR() -FIXED LENGTH CHARACTER STRING
10 DATE
11 DECIMAL
12 DECIMAL
13 DECIMAL
Default filename for output data file is TS2T5.DEL,
do you wish to change filename used? y/n
Filename used for output data file is TS2T5.DEL. If existing file,
data will be appended to it.

Formatted data being dumped ...
Dumping Page 0 ....
Dumping Page 1 ....
Table object data formatting end.

______________________________________

The requested DB2DART processing has completed successfully!
All operation completed without error;
no problems were detected in the database.
______________________________________

Complete DB2DART report found in: SAMPLE.RPT

_______ D A R T P R O C E S S I N G C O M P L E T E
_______


some of the rows which are not maching in the dumped .del file

"000130","DOLORES","M","QUINTANA","C01","4578",197 10728,"ANALYST
",16,"F",19250915,+0023-00.00,+0000500.00,+0001-04.00

000130 DOLORES M QUINTANA C01 4578
07/28/1971 ANALYST 16 F 09/15/1925 23800.00 500.00
1904.00

"000020","MICHAEL","L","THOMPSON","B01","3476",197 31010,"MANAGER
",18,"M",19480202,+0041250.00,+0000-00.00,+0003300.00

000020 MICHAEL L THOMPSON B01 3476
10/10/1973 MANAGER 18 M 02/02/1948 41250.00 800.00
3300.00

"000340","JASON","R","GOUNOT","E21","5698",1947050 5,"FIELDREP",16,"M",19260517,+0023-40.00,+0000500.00,+0001-07.00

000340 JASON R GOUNOT E21 5698
05/05/1947 FIELDREP 16 M 05/17/1926 23840.00 500.00
1907.00


I have noticed that the values in the last 3 columns of the dumped
.del file data are not matching the same in the actual tables from the
database. the dashes (-) represent either digit 8 or digit 9.

any idea why this is happening? I use Redhat 7.3 UDB 7.2 Fixpack 5.
This is a sample database.

thanks in advance,
dotyet

Nov 12 '05 #3

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

Similar topics

11
by: Michael Lang | last post by:
You'd think that the advantage to extra decimal places in a data type is better accuracy. Well think again. Look at this method and test results: ...
1
by: allenj | last post by:
Are the following true statements? On v7, db2dart should only be run against an activated db with no connections. On v8, db2dart should only be run against a deactivated db (which of course...
0
by: xixi | last post by:
we are using db2 udb v8.1 on win 64 bit with fp3 with type 4 db2jcc.jar driver. i use db2dart analyze one database. one of the tablespace (database managed) has this error, please help me...
3
by: mairhtin o'feannag | last post by:
I keep getting the following when I run DB2DART /LHWM to reset the HWM : Warning: The database state is not consistent. Warning: Errors reported about reorg rows may be due to the inconsistent...
2
by: Brice | last post by:
Hello, Sorry if this is a basic question but I can't seem to find the answer in the DB2 tutorial series or my DB2 manuals. How does one check the data integrity and referential integrity of an...
6
by: Thomas Lumley | last post by:
What does the standard guarantee about the accuracy of eg the trigonometric functions? There is obviously an implementation-dependent upper bound on the accuracy, since the answer is stored in a...
1
by: coop | last post by:
I'm trying to port a high-accuracy reaction-time gathering application from a RTLinux C implementation into a web-avaliable implementation. We're obviously expecting to lose some accuracy and...
1
by: aj | last post by:
What is the difference (if any) between inspect check database and db2dart ??? Do they both find the same potential problems? Does one provide more comprehensive checking than the other? ...
5
by: Sensei | last post by:
Hi again! I am trying to figure a simple example of a program that shows the accuracy differences between float and double types. In particular I'm searching for an operation that works on...
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...
1
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...
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: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.