http://www.dbatodba.com These are the search results for the query, showing results 1 to 7. http://www.dbatodba.com/Forums/db2/645841268/867813700 Log shipping is the name given for moving the logs from primary site to DR site so that the database can be roll forward and bring back to connecitng state in case of a disaster. Implementing it requires creation of script which will move the archived logs to the disaster site. No publisher spider007 2008-08-21T04:56:11Z Comment http://www.dbatodba.com/Forums/db2/135718914/543433545 I am not sure whether you got the response for this one or not, but here it is: 1. you have to add db2profile in the .profile of this new user C 2. You will have to catalog the databases for instance A and B 3. you can grant privileges for select only to user C for db running on A and B by using the GRANT command. No publisher spider007 2008-08-21T04:53:23Z Comment http://www.dbatodba.com/Forums/db2/861932502/476182142 Oh, just one more thing, for the first query to give you a good result, ensure that your statistics are updated. No publisher spider007 2008-08-21T04:50:16Z Comment http://www.dbatodba.com/Forums/db2/861932502/476182141 1. Easy way: In DB2 9.5, use this query " select substr(a.tabname,1,30) as tabname,substr(a.COLNAME,1,30) as colname,b.card,a.NUMNULLS from syscat.columns a, syscat.tables b where a.tabname = b.tabname and a.TABSCHEMA = b.TABSCHEMA " 2. Hard way: Consider this table, A -----------           1           2           3           4           -           1           2           3           4           -           1           2           3           4           -   15 record(s) selected. Issuing the query " select x.a,x.cnt,x.sumcnt from (select a,count(1) as cnt ,sum(count(1)) over() as sumcnt from sj1  group by a) as x where x.a is null " A           CNT         SUMCNT ----------- ----------- -----------           -           3          15   1 record(s) selected. You can use this to create a script. OR, No publisher spider007 2008-08-21T04:49:18Z Comment http://www.dbatodba.com/Forums/db2/620410355/326974487 updates as in transactional updates or DDL updates? No publisher spider007 2008-08-21T04:35:02Z Comment http://www.dbatodba.com/Forums/db2/150721273/721883344 Check this out as well http://www.ibm.com/developerworks/exchange/dw_entryView.jspa?externalID=326&categoryID=977 No publisher spider007 2008-08-21T04:34:00Z Comment http://www.dbatodba.com/Forums/db2/400831561/981208182 If the other user is able to connect, you would find the same statements as mentioned by perallis No publisher spider007 2008-08-21T04:30:44Z Comment