Hi I have to move one database from NT to UNIX and only way s using db2move. But the database has tables with blob data and what is the best way to move them? Any suggestions are invited. Kish >From: "McLeod, Scott" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: [EMAIL PROTECTED] >Subject: RE: DB2EUG: get database names >Date: Thu, 14 Jun 2001 10:08:47 -0500 > >I can help you out there. It was actually just a small subroutine that >could easily be replaced by a variable set command that might work >something >like below. I only used a subroutine to keep my utilities modular. > > >DATABASES=`db2 list database directory | grep alias | cut -c36-45`" > >In NT world, I do this: > >DATABASES="`db2cmd /c /w /i db2 list database directory | grep alias | cut >-c36-45`" > >I also find it is sometimes needed to filter out those databases from the >list that I don't want the script to run on. For example, a remote >cataloged database I don't want backed up in my backup script. Since all >our remote databases at my company begin with the string DRX, I modify the >command now to look like this: > >DATABASES=`db2 list database directory | grep alias | cut -c36-45 | grep -v >DRX`" > > > > > > > -----Original Message----- > > From: Shi, Zhong [SMTP:[EMAIL PROTECTED]] > > Sent: Thursday, June 14, 2001 7:48 AM > > To: [EMAIL PROTECTED] > > Subject: DB2EUG: get database names > > > > List, > > In the DB2START_TXT Unix Scripts writen by Scott, I saw there is a call >to > > get.database.name. If any body have that file, please email me a copy. > > Thank you. > > > > Zhong Shi > > DBA > > First Coast Services Options > > > (904) 791-0282 > > > [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > ===== > > To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] > > For other info (and scripts), see > > http://people.mn.mediaone.net/scottrmcleod > >===== >To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] >For other info (and scripts), see >http://people.mn.mediaone.net/scottrmcleod > _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
