I need to deactive these datbases after restarting instance

smith43017 · #1 (**permalink**) 01-17-08, 15:38

if [ ${dbfile}='DBPTLFEP'||${dbfile}='DBPTLLMP']; then
db2 deactivate db ${dbfile}
fi

I want to deactivate dbs if name are DBPTLLMP,DBPTLFEP the vales I am reading from flat file.

smith43017 · #2 (**permalink**) 01-17-08, 15:39

Can some body can let me know what I am doing wrong

stolze · #3 (**permalink**) 01-17-08, 18:23

Please see my response in the Unix Shell Scripts group. You should read the man page for "test"

Code:

$ man test

It describes exactly how conditions have to be written in shell script.

smith43017 · #4 (**permalink**) 01-18-08, 11:53

Thanks Stolze

smith43017 · #5 (**permalink**) 01-18-08, 11:54

Code:

db2 list db directory|grep -p Indirect|grep -E "alias"|cut -c41-49>dbs
while read dbfile
do
if [ "${dbfile}" = 'DBPTLFEU' -o "${dbfile}" = 'DBPTLLMU' ]; then
    db2 deactivate db ${dbfile};
else
 db2 connect to ${dbfile};
 echo ${dbfile} 
 db2 -tvf ptldeadevnt.sql 
 db2 connect reset>/dev/null
fi
done < dbs

Internet Services

Web Development

Digital Marketing

Consumer Tech