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

    bind validate

    Rajakumar, I believe this has been the case on previous installations I've worked on. Am I missing something, hence the question? Greg
  3. gregsimpson

    Read-only view

    Could it be that although you've given ultimte permissions and authorities on the view, your user is only read only on the base table and that's overriding it? Greg
  4. gregsimpson

    How do I determine if a table is locked?

    Ties, I use DB2 on AIX and in my testing systems I have many instances, all containing many databases, all on the same server. Just thought it worth pointing out. Cheers Greg
  5. gregsimpson

    db2fmp gone mad

    ionobelisk, nice spot. I'll double check everything my IBM consultant tells me from now on. We've had problems with this and what you've said backs up what I've seen as regards 1 and only stored procedure, which we run. Greg
  6. gregsimpson

    Does database index need to be made for "ORDER BY" clause??

    fletchsod, you don't need to make indexes for either the where clause or the order by clause. However 9 times out of 10, indexes which have been defined to support your processing, will greatly enahnce the performance you get from your database. You may wish to consider other performance...
  7. gregsimpson

    Restore of a Back by Tablespace

    Kozlow, is this your problem? http://www-1.ibm.com/support/docview.wss?uid=swg1JR20798 Cheers Greg
  8. gregsimpson

    What does this mean

    It's as regards the processing it will do on your "field" when it retrieves it. There's an explanation of digits here http://www.idugdb2-l.org/adminscripts/wa.exe?A2=ind0111a&L=db2-l&T=0&F=&S=&P=22044 The substr is saying use from characters 1 to 9. So effectively on retrieval your field...
  9. gregsimpson

    ERROR ON ALTER COLUMN

    Similar problem here? http://www.dbtalk.net/ibm-software-db2-udb/sql0443-sql0204-altobj-106492.html Cheers Greg
  10. gregsimpson

    DB2 Trace/Profiler

    db2trc ? Cheers Greg
  11. gregsimpson

    DB2 Trace/Profiler

    Hi, easy here too. Use an event monitor. http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/admin/r0005991.htm Cheers Greg
  12. gregsimpson

    Replication

    Mag007, 2 databases on the same system, will work equally well. There's a number of options open to you, in terms of setting up replication, you can use the GUI, use SQL (means you need to understand the internal replication asn... tables) or a new scripting language for replication call...
  13. gregsimpson

    Select records from table one which are not match

    Dan, I have a typo in the above. I should have shown in my second example the word except, rather than intersect. Some examples from the web http://publib.boulder.ibm.com/infocenter/iadthelp/v6r0/index.jsp?topic=/com.ibm.etools.iseries.langref2.doc/rbafzmstmark.htm...
  14. gregsimpson

    Select records from table one which are not match

    Not had time to look at the post in detail. Just thought it's worth mentioning there is an except operator to find results in one result set, which aren't present in another. Additionally, there is am intersection operator, which finds the elements tha belong to two different result sets...
  15. gregsimpson

    Identify a db2 backup file type

    Martyn, not got db2 in front of me today. Have you tried commands such as db2 list history backup Cheers Greg
  16. gregsimpson

    Do I have to re-install?

    I had a similar problem recently only on AIX. The codebase on AIX doesn't yet support LDAP, so we had to back out the LDAP implementation. Cheers Greg
  17. gregsimpson

    Problem starting the DB2 DAS

    Can you post some diagnostics, such as error message, from db2diag.log or .nfy file. Also the full text of the commands you are issuing and what return you get. Cheers Greg
  18. gregsimpson

    Type of data problem

    julen, I thibk you could accomplis this, by describing your data in XML. http://www.tdan.com/i024hy01.htm Greg
  19. gregsimpson

    Type of data problem

    julen, I understood CLOBS were for the purpose of storing documents etc. Whether it supports all your requirements, I can;t say, as I've not used them. There's a link here to get you started with further research, should this be a possibility...
  20. gregsimpson

    Encountering "...transaction log...full" error

    Mufasa, to check what you're logging parameters are currently set to 1) connect to the database 2) Issue db2 get db cfg The line you're interested in are as follows Log file size (4KB) (LOGFILSIZ) = 1000 Number of primary log files (LOGPRIMARY) = 3...

Part and Inventory Search

Back
Top