Does anyone have a UNIX korn shell example to just get the local (i.e. Directory entry type = Indirect) databases? Thanks, Gary Scarcella. [EMAIL PROTECTED]
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 3:44 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [DB2EUG] How can I get a listing of local databases via a db2 command line. Tim , In Unix, I have a short Shell that get me back just the LOCAL databases, avoiding ALIAS or REMOTEs. You can traslate it to W/NT. ================================================ #!/bin/ksh # $HOME/sqllib/db2profile; # # The parameter |sort|uniq will filter the same DB's and get the output for just one DB # LOCALDBNAME=`db2 list database directory |grep 'Database name' |awk '{print $4 }' |sort|uniq` echo $LOCALDBNAME # ================================================= Maybe it can help you. Miguel Celi DB2 DBA Northern Trust Bank Chicago Subj: [DB2EUG] How can I get a listing of local databases via a db2 command line. Date: Thu, 21 Mar 2002 2:52:25 PM Eastern Standard Time From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Hello list, I am currently working on some automation and want to know of a way to get a listing of only the local databases that are cataloged on a machine. I thought the list active databases might be the direction to go, but would only be effective if all of the databases had a connection at all times. Apparently that is not the case here. DB2 UDB NT version 6.1 REXX for Windows Anyone have any other ideas? Thanks, Tim Traxson [EMAIL PROTECTED] 479-820-8811 - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
