Recent content by dbmsguy

Thanks, I'm actually looking for the UDB 8.2 version (unix) which runs differently than the OS/390 version Paul www.dbmsguy.com

We here have been trying out the online (inplace) reorg feature of v8.2 UDB. As part of this we have been doing application testing and system monitoring. One of the things noted, is the following: 1. We note that a lot of locking is going on 2. We note that there is a lot of transaction log...

Excellent suggestion..... the DTS pkg seems to solve my problem.... the idea of excel is probably a good one, however I have millions of rows, so it falls down there. Thanks for the help! A star for youi Paul www.dbmsguy.com

I am trying to move data from one dbms to another. in my target dbms, I need to have double quotes around the character data and the columns delim by a comma.... I can't seem to get bcp to put the data out in this format .. has anyone done this before or suggest a way to get this done? Paul...

I am trying to move data from one dbms to another. in my target dbms, I need to have double quotes around the character data and the columns delim by a comma.... I can't seem to get bcp to put the data out in this format .. has anyone done this before or suggest a way to get this done? Paul...

Thanks for you comments. Helpful. [2thumbsup] Paul www.dbmsguy.com

I would say that it is failing on the first get. I say this because, for the most part there is only one clob w/length > 0. So it must be. As well, generally this does not fail frequently. Actully, in my development env (winNT using VAJ as IDE), it happens frequently, but using exactly the...

Exception in thread "main" COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/6000] SQL0423N Locator variable "1" does not currently represent any value. SQLSTATE=0F001 I am sporatically getting the above error and don't know how to determine the problem. From the...

try using ROWNUMBER() Paul www.dbmsguy.com

try doing: alter tablespace tsname switch online Paul www.dbmsguy.com

very good. thank you again Greg. Paul www.dbmsguy.com

Thank you for the interesting link.... I might tend to disagree with you on the second point. If, you do have a nullable column, and it is indeed null, then to the best of my knowledge, it does not actually store the placeholder. In other words, if you have a char(10) nullable and put in a...

I remember either reading or hearing from a ways back that DB2 (UDB 7.2 on AIX specifically) automatically stores (internally) varchars and nullable columns at the end of the table. This goes back to the old argument that varchars 'should' be put at the end of a table. At any rate, I am trying...

thank you all for you suggestions..... Paul www.dbmsguy.com

i am getting the following message from one of my awk pgms.... it's because the Rec Size is too large. any one know a way around this?? awk: 0602-534 Input line 2002-01-09-11.49.52. cannot be longer than 10,239 bytes thanks, Paul Paul www.dbmsguy.com