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 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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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:
...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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?
...
|
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...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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)...
|
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...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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....
|
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...
| |