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: *

  • Users: dbmsguy
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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
  7. 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...
  8. dbmsguy

    win2000 crashes during boot sequence

    I have been going nuts with this problem. I am installing win2000 prof workstation and the system has continual problems crashing during the boot seq. i am at SP2. below is the dump that i get..... any suggestions??? it always dies just like this. I can always get it up in safe mode and...
  9. dbmsguy

    I don't know if this is the correct

    I don't know if this is the correct forum, and if not, please feel free to redirect me... my problem is somewhat network related... here is my config 1. windows 2000 with two eth cards. card 1 - my cable modem eht card card 2 - a second card which is connected to a crossover cable...
  10. dbmsguy

    overhead of running sql profiler

    A question has been raised in my company regarding what the overhead of running sql profiler is.... I am looking for a white paper or some sort of documented benchmarking around this activity. I have looked over the net to no avail, does anyone know of a resource? Paul www.dbmsguy.com
  11. dbmsguy

    summarizing my data correctly

    Consider the following tables which reside on a sql 7 db date servername dbname dbid groupid groupname fileid filesize maxfilesize growth name...
  12. dbmsguy

    technology convergence

    Just a thought of the future.... What I believe we will be seeing over the next bunch of years is more technology convergence. We are already starting to see it now with things like wireless technology converging with other products. internet over the phone banking over the internet cash...
  13. dbmsguy

    sysobjects column 'loginame' conflict

    I have run into an interesting senario on ASE 12.0 consider the following. we had a requirement for an application to perform a conversion. as part of the conversion (3rd party), it wanted to drop and create tables and stored procs. the application normally access everything from a user...
  14. dbmsguy

    good awk/sed reference book needed

    Can anyone suggest a good awk/sed reference book. the only one i have is the o'reilly book. it's ok as a learning tool, but I find it is bad as a reference book any suggestions would be appreciated (especially if it included the isbn) Paul www.dbmsguy.com
    • dbmsguy
    • Thread
    • Replies: 3
    • Forum: AWK
  15. dbmsguy

    sp_ from master not returning expected results......

    for your consideration I am in the midst of writing a process to monitor database stats for capactiy planning reasons. senario 1. in query analyzer I run: use spacetest go select db_name(),db_id(),coalesce(a.groupname,'log') , a.groupid, b.fileid, (convert(dec(12,2),b.size) *8/1024) ...
  16. dbmsguy

    cross server joins - microsoft sql server

    I am currently in a situation where we are required to do cross server joins for several warehouse/mining type queries..... the joins are killing us performance and server wise.... i am looking to find someone/doc or whatever that can give more info on how cross server joins are managed...

Part and Inventory Search

Back
Top