http://www.dbatodba.com These are the search results for the query, showing results 1 to 12. http://www.dbatodba.com/db2/scripts-db2/mirror-online-db-with-automated-rollforward Imagine you have a huge DB which cannot be stopped to mirror with db2inidb or alter instance parameters, maybe this little script will help you. No publisher owindels 2011-08-02T21:34:17Z Page http://www.dbatodba.com/db2/ssh-passing-password-from-script Sometimes you want to automate the execution of commands on each DB2 server you own from a computer where there is no db2 client installed. Here is a little trick showing you how to do it. No publisher owindels 2011-07-25T13:36:29Z Page http://www.dbatodba.com/db2/save-current-db-cfg-from-all-your-dbs-to-separate-files A useful script you can use to keep track of you actual db configuration before migrating to another version of DB2. No publisher owindels 2011-06-15T23:24:09Z Page http://www.dbatodba.com/db2/scripts-db2/shell-scripts-to-db2/the-recovery-history-file The recovery history file keeps track of many useful events. Use scripts or administrative views to export and format the data contained in this file for future use. No publisher owindels 2011-02-14T14:04:17Z Page http://www.dbatodba.com/Forums/db2/360853029/125788994 Hi Kanaka, I have no practical experience with federated databases, but I think you'll find what you need in these topics: - http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.swg.im.iis.db.fed.overview.doc/topics/cfpint25.html - http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.swg.im.iis.db.found.conn.fw.opt.doc/topics/rfpapcat.html Since all the information you need resides in the global catalog, you'll just have to mount your select according to the global catalog views. Just select the information from the local table and the other referenced by its nickname... add a clause like "where not exists" and you should have what's in one and not the other. Good luck! Olivier No publisher owindels 2010-09-14T15:37:54Z Comment http://www.dbatodba.com/Forums/db2/360853029/421665111 Hi, Are those federated databases or just two independent databases like for instance: one for homologation and the other for production environment? Olivier No publisher owindels 2010-09-14T11:42:23Z Comment http://www.dbatodba.com/db2/how-to-do/merge-variant-automerge How to use the merge command to update and insert data from and into the same table? Merge variant: Automerge! No publisher owindels 2010-05-04T20:17:26Z Page http://www.dbatodba.com/db2/useful-aix-commands/how-to-get-a-csv-list-of-system-users Sometimes you need to get a list of users to generate a script like governor´s config file. All your users must have a common name pattern, in this case: usr0. No publisher owindels 2010-03-17T12:40:34Z Page http://www.dbatodba.com/Forums/db2/974092193/240509145 Previously kanakarajuy wrote: Can any body share the practical document which provides step by step informaton about the SQL replication in db2? Regards kanak http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.swg.im.iis.db.repl.sqlrepl.doc/topics/iiyrscncsqlreplovu.html Regards, Olivier No publisher owindels 2010-02-28T04:27:24Z Comment http://www.dbatodba.com/db2/scripts-db2/shell-scripts-to-db2/update-parameter-value-from-all-your-dbs Based on another script, this one can update a parameter value for all the db´s you have in a single instance. To run it, supply parameter name and value. No publisher owindels 2010-02-19T18:54:02Z Page http://www.dbatodba.com/db2/scripts-db2/shell-scripts-to-db2/check-parameter-value-from-all-your-dbs-ii I encountered an issue when the Directory entry type was Remote... here is the fix. Just supply the name of the parameter when you run the script. No publisher owindels 2010-02-19T18:51:01Z Page http://www.dbatodba.com/db2/scripts-db2/shell-scripts-to-db2/check-parameter-value-from-all-your-dbs This script allows you to check what are the current and delayed values of a single database configuration parameter. Just supply the name of the parameter when you run the script. No publisher owindels 2010-02-09T15:23:47Z Page