In Solaries and DB2 environment

I need to use in script to force application one by one in a loop

can you please help me out guys


Thanks in advance

Something like this?
Not tested.

It's working great and thank you

db2 "force application(302)"
db2 "force application()"

How can Trip the bottom line of that script above

By thw way Thanks N_I,

I chnaged minorchnage

db2 list applications | awk 'NR>4 {print "db2 \"force application(" $3 ")\"";}'

But I need to trim extra line in the bottom from given bellow

db2 "force application(315)"
db2 "force application(314)"
db2 "force application(312)"
db2 "force application()"

please some body can help me

try awk 'NR>4 && $3 {print "db2 \"force application(" $3 ")\"";}'

thanks Once again

db2 list applications | awk 'NR>4 && $3 {print "db2 \"force application(" $3 ")\"";}'

I am getting syntax error

awk: syntax error near line 1
awk: bailing out near line 1

That must be something about your awk implementation; my gawk works fine. Try reading the manual.

awk and gawk are not the same application - it can work differently. I always use gawk where possible.

it si working in AIX environment


db2 list applications | awk 'NR>4 && $3 {print "db2 \"force application(" $3 ")\"";}'