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

    AIX Printer Problem

    Printer set up. Can be printed to via root from command line and also via X-Print. Any non root user can use X-print and it works, however and non root user can't print from command line. We've checked the obvious being permissions, on commands and print queues. Any ideas please? Cheers Greg
  2. gregsimpson

    Varchar

    Does anyone know how the internal structure of Varchard works on LUW V8.2. I have someome proposing a VARCHAR(6) for a column which is predominantly empty. Essentially I am wondering how many bytes an empty VARCHAR takes up. Does that make sense? Cheers Greg
  3. gregsimpson

    Quiesce

    Does anyone know if it's possible to query quiesce points and if so how. I'm on DB2 V8. fixpack 8 LUW running on AIX. Cheers Greg
  4. gregsimpson

    Export Data

    Hi, moving across from the DB2 forum to the Oracle forum, so apologies for starting failry high level. I have requirement to export data from a number of Oracle tables under 9i. The requirement basically splits into 3, some tables need exporting in CSV, some need exporting in fixed width and...
  5. gregsimpson

    TSM RE-Directed restore

    Does anyone know how to (in laymans terms) do a re-directed restore using TSM and V8 UDB on AIX. Any hep or pointers are much appreciated. Cheers Greg
  6. gregsimpson

    Current Server

    Hi, I am unable to get a Websphere connect using JDBC 4 to work selecting the following select current server from sysibm.sysdummy1 Does anyone know a way around this, maybe a clever way I can do it in a view? I looked at the supplied table function in fix pack 9, which would have done what I...
  7. gregsimpson

    Event Monitoring

    I'm trying to create an event monitor using the Control Centre V8.2. I've selected all the options as regards event type and given the monitor a name. However I need for it to write to table in a particular tablespace (which is not the default tablespace) and so far the syntax has beaten me...
  8. gregsimpson

    Sed Variable Substitution

    Hi, I have a script using sed, which is getting ite commands for sed from a file, as I wish to use multiple commands. Unfortunately using the file in this way to drive sed, doesn't appear to do substitution of variables. If this is something I'm stuck with can someone else recommend a neat way...
  9. gregsimpson

    Retrieve Instance Details

    Hi, AIX Machine running DB2 8.1. I'm trying to establish certain settings with SQL. I'm afer the instance and the database. I can get the database by issuing db2 "select current server from sysibm.sysdummy1" Does anyone know of a way of getting the instance? Cheers Greg
  10. gregsimpson

    Increment Row Number

    I posted the following on the DB2 board but they have not been able to help. Anyone over here any ideas please. Thanks Greg I have inherited the following table on OS/390 DB2 version 5. Unfortunately DB2 Version5 on OS/390 doesn't have the nicer features such as rowid and sequence. The table...
  11. gregsimpson

    Sequence Number

    I have inherited the following table on OS/390 DB2 version 5. Unfortunately DB2 Version5 on OS/390 doesn't have the nicer features such as rowid and sequence. The table looks as below Customer Bacs_Amt Bacs _Date Bacs_Name Bacs_Row_Num 000000001 29.30 29/02/2002 Pension 0...
  12. gregsimpson

    TIME

    Can anyone tell me what the 3 values as returned by TIME in the example below represent. $ time db2 <gregfile >outfile real 1m48.64s user 0m4.17s sys 0m11.33s
  13. gregsimpson

    How do I find out which groups my U

    How do I find out which groups my UNIX logon is connected to on an AIX box?

Part and Inventory Search

Back
Top