Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
What does db2drdat do, trace data stream for DRDA users or all users?
Hi All, Although the book says db2drdat "Allows the user to capture the DRDA data stream exchanged between a DRDA Application Requestor (AR) and the DB2 UDB DRDA Application Server (AS) " , it actually captures data stream from local users, not only DRDA users. The cmd I used is: db2drdat on -r... -
how to see DDL for an existing table/view
For individual tables, use command: describe table table-name -
lenght of Numeric field
According to your need, function length(char(col-name)) may work for you. -
Search Discovery Doesn't Work?
Most likely not. I think this is the problem. Thank you for the hint. -
Search Discovery Doesn't Work?
DAS is up and running, that's for sure. If DAS is not running, Known Discovery doesn't work. Thanks. -
Search Discovery Doesn't Work?
All, I am running DB2 ESE 8.1 on Linux as a server and the same thing on Windows XP as a client. I also have the following setting: DAS cfg on the server: DISCOVER = SEARCH DBM cfg on the server: DISCOVER = SEARCH DISCOVER_INST = ENABLE DBM cfg on the...
