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!

  • Congratulations Chriss Miller 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. sathyarams

    recovering database access from TSM in DB2

    just issue a backup command db2 backup db <dbname> to NUL or db2 backup db <dbname> Then you can change the parm to whatever you want. db2dart also has an option for unsetting the backup pending state, but the above method is a safer one. HTH Sathyaram More DB2 questions answered...
  2. sathyarams

    DB2 Backup in LiveVault

    You can suspend writes on the database and then "vault" your data. Recently, there was a discussion on using Dell Compellent for DR on another forum http://www.dbforums.com/db2/1675748-hadr-setup-issues.html Appreciate LiveVault is different [ and I admint, I have no experience with it ]...
  3. sathyarams

    How to reduce size of DB2 log file c0000000.lrg

    This is not log. This is large tablespace container. You have to delete the data in the table that is using this container and do a reorg with LONGLOBDATA option. You cannot do an inplace reorg when using this option HTH Sathyaram For db2 resoruces visit www.db2click.com More DB2 questions...
  4. sathyarams

    Help with Recursive Query

    To "tutorial" on recursive query can be found here. http://www.ibm.com/developerworks/data/library/techarticle/0307steinbach/0307steinbach.html For db2 resoruces visit www.db2click.com More DB2 questions answered at www.dbforums.com/f8 & http://www.idug.org/user/UserLogin.asp
  5. sathyarams

    Program Gets DB2 SQL Error After 4600 Commits

    or, it could be this. https://www-304.ibm.com/support/docview.wss?uid=swg21115245 For db2 resoruces visit www.db2click.com More DB2 questions answered at www.dbforums.com/f8 & http://www.idug.org/user/UserLogin.asp
  6. sathyarams

    clearing or flusing DIR_CACHE in DB2

    No, you do not need to stop/start when you add something new If an entry is not found in the cache, it is read from the disk. HTH Sathyaram For db2 resoruces visit www.db2click.com More DB2 questions answered at www.dbforums.com/f8 & http://www.idug.org/user/UserLogin.asp
  7. sathyarams

    Manual Scripts to Perform HADR Failover

    http://www.dbforums.com/db2/1663997-manual-scripts-perform-hadr-failover.html discussion on the same topic(same poster) here. Tek-tippers may have more to add For db2 resoruces visit www.db2click.com More DB2 questions answered at www.dbforums.com/f8 & http://www.idug.org/user/UserLogin.asp
  8. sathyarams

    Data Compare between UDB and DB2 Z\OS

    Have you tried using Federation? ie, you define a nickname to access your remote zos table in your UDB database. once you do this, then you can issue select pkcol1,pkcol2 from zostable_nickname except select pkcol1,pkcol2 from luwtable this should return 0 rows.. For db2 resoruces visit...
  9. sathyarams

    Insert Select From - Not All Columns

    insert into table_a select 'val1','val2','val3',x from table_b For db2 resoruces visit www.db2click.com More DB2 questions answered at www.dbforums.com/f8 & http://www.idug.org/user/UserLogin.asp
  10. sathyarams

    How to create DB2 database using Php code?

    i guess you have to use shell-exec or a similar function to do this.. once u create the db, then you connect to it and can do other db operations, just like you would with any database. hth sathyaram For db2 resoruces visit www.db2click.com More DB2 questions answered at...
  11. sathyarams

    view existing grants on a database / table

    search for "Security routines and views" in the information centre for your version of the product Sathyaram For db2 resoruces visit www.db2click.com More DB2 questions answered at www.dbforums.com/f8 & http://www.idug.org/user/UserLogin.asp
  12. sathyarams

    view existing grants on a database / table

    What version and fixpak are we talking about here ? For db2 resoruces visit www.db2click.com More DB2 questions answered at www.dbforums.com/f8 & http://www.idug.org/user/UserLogin.asp
  13. sathyarams

    Curious question

    There are numerous limitations when using common table expressions in iSeries. I remember reading a document explaining the limitations, but unable to find it now For db2 resoruces visit www.db2click.com More DB2 questions answered at www.dbforums.com/f8 & http://www.idug.org/user/UserLogin.asp
  14. sathyarams

    cannot recreate DB after dropping !!!

    db2 list db directoy and look up the local database directory for the database. db2 list db directory on <dirname> will show you that database name you can do db2 uncatalog database <dbname> on <dirname> I do realize that the question is 3+ months old, but am hoping it will be of help...
  15. sathyarams

    523 port

    i don't think you can setup 'accesslist' for port 523 from within db2. you can disable discovery at the admin server and instance levels. db2 get admin configuration db2 get dbm cfg and look for discovry / discover_inst parms For db2 resoruces visit www.db2click.com More DB2 questions...
  16. sathyarams

    db2 rebind error

    I would do a db2iupdt, just in case some installation file is corrupted/permission changed etc. For db2 resoruces visit www.db2click.com More DB2 questions answered at www.dbforums.com/f8 & http://www.idug.org/user/UserLogin.asp
  17. sathyarams

    Query another table for data

    You have to use Left outer join as Marc said. SELECT * FROM tab_a a left outer join tab_b b on a.site=b.site For db2 resoruces visit www.db2click.com More DB2 questions answered at www.dbforums.com/f8 & http://www.idug.org/user/UserLogin.asp
  18. sathyarams

    Db2 auditory

    What do you want to audit ? For db2 resoruces visit www.db2click.com More DB2 questions answered at www.dbforums.com/f8 & http://www.idug.org/user/UserLogin.asp
  19. sathyarams

    Db2 error while loading

    Check the DB2 manuals The error code descriptions for 9.1 are in http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.codes/00e40318.htm For db2 resoruces visit www.db2click.com More DB2 questions answered at www.dbforums.com/f8 &...
  20. sathyarams

    UPDATE SQL FOR QUERY400 - AS400 STRSQL

    Can you post the statement you are trying and of course, the error message. For db2 resoruces visit www.db2click.com More DB2 questions answered at www.dbforums.com/f8 & http://www.idug.org/user/UserLogin.asp

Part and Inventory Search

Back
Top