Search results for query: *

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

i might also suggest that you set a table lock before the inserts. by doing this you will reduce the overhead of maintaining locks. this would of course presume that you are the only one using the table at the time and would have to be done as part of a transaction. Paul www.dbmsguy.com

i have figured out my problem: 1. turn on a full memory dump on error 2. when the error happens I get a blue screen with the offending program.... in this case it was bsudfrdr.sys. this is for my udf reader from ahead software for my cd burner. uninstalled the udf reader and all works. so...

what I ended up doing was: 1. rename the registry entry to _old 2. rename the mssql folder to _old 3. reinstall sql 7 4. remove old folder and registry entry. all seems to work fine, so I assume this to be a valid method... Paul www.dbmsguy.com

check out optdiag command. there are a number of indicators in it that will help. Paul www.dbmsguy.com

when I try to uninstall SQL 7 on my WIN2K machine, i get error saying that c:\mssql7\uninst.isu is corrupt. is there any suggestions as to how to get it out of my system? one thought was to get rid of all of the registy entries for it and then try to reinstall... but then, maybe that would...