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!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dbmsguy

    V8.2 online reorg

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

    V8.2 online reorg

    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...
  3. dbmsguy

    bcp character output surrounded by double quotes

    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
  4. dbmsguy

    bcp character output surrounded by double quotes

    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...
  5. dbmsguy

    bcp character output surrounded by quotes

    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...
  6. dbmsguy

    Sporatic SQL0423N message

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

    Sporatic SQL0423N message

    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...
  8. dbmsguy

    Sporatic SQL0423N message

    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...
  9. dbmsguy

    Is there any column in DB2 like "ROWNUM" in oracle?

    try using ROWNUMBER() Paul www.dbmsguy.com
  10. dbmsguy

    Table space in offline state.

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

    table storage internals

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

    table storage internals

    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...
  13. dbmsguy

    table storage internals

    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...
  14. dbmsguy

    Input line too long message

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

    Input line too long message

    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
    • dbmsguy
    • Thread
    • Replies: 4
    • Forum: AWK
  16. dbmsguy

    How to bulk load data into DB2 V7.2 ??

    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
  17. dbmsguy

    win2000 crashes during boot sequence

    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...
  18. dbmsguy

    can't uninstall sql 7

    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
  19. dbmsguy

    Re-Org on a table

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

    can't uninstall sql 7

    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...

Part and Inventory Search

Back
Top