Recent content by sathyarams

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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