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.EMPLOY EE,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","DOLOR ES","M","QUINTA NA","C01","4578 ",19710728,"ANA LYST
",16,"F",192509 15,+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","MICHA EL","L","THOMPS ON","B01","3476 ",19731010,"MAN AGER
",18,"M",194802 02,+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",19 470505,"FIELDRE P",16,"M",19260 517,+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  3705 
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.EMPLOY EE,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","DOLOR ES","M","QUINTA NA","C01","4578 ",19710728,"ANA LYST
",16,"F",192509 15,+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","MICHA EL","L","THOMPS ON","B01","3476 ",19731010,"MAN AGER
",18,"M",194802 02,+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",19 470505,"FIELDRE P",16,"M",19260 517,+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******@ameri tech.net> wrote in message news:<%S******* *********@newss vr16.news.prodi gy.com>... 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.EMPLOY EE,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","DOLOR ES","M","QUINTA NA","C01","4578 ",19710728,"ANA LYST
",16,"F",192509 15,+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","MICHA EL","L","THOMPS ON","B01","3476 ",19731010,"MAN AGER
",18,"M",194802 02,+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",19 470505,"FIELDRE P",16,"M",19260 517,+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:
===========================================================
// not just for rounding decimals, but for getting nearest
// whole number values. IE. Nearest(443, 5) = 445
public static double Nearest(double source, double nearest)
{
//method 1 - uses modulus operator
|
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 implies that there are no connections)
-------------------------
In my v7 dead tree manuals, I can find no mention of db2dart in the
|
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 understand this. thanks
Traversing extent map for:
OTR ID: 17
Parent object ID = 17 pool ID = 4
|
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
state of the database.
DB2DART Processing completed with warning(s)!
Complete DB2DART report found in:
/home/db2gen/sqllib/db2dump/DART0000/GEN.RPT
|
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 instance before running
a backup? I see how one can run "db2ckbkp" after the backup has run,
and I've seen some discussion of checksums in past postings, but what
I'm looking for is more of:
#!/bin/sh
| | |
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 double,
but is this bound actually achieved?
First, a simple example
Suppose I want the arc cosine of -1, and use acos(-1.0) to compute it.
The correct answer to 25 hexadecimal digits is
-3.243F6A8885A308D313198A2E. This falls between two ...
|
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 functionality, but
I need to know exactly how much accuracy we will lose.
So-
1) How accurate and precise are the Date object and setTimeout
function? Do both work off the same clock, and if so, what is the
clock, and is it uniform across most...
|
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?
TIA
|
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 doubles, but fails on floats,
and my first guess was an eigenvector problem (using the power method).
Unfortunately I found that they work ok in both cases, and I'm
concerned about optimizations and "smart promotions" by the compiler
I'm using...
|
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: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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: 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: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
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.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
