topic Re: Simple shell script question in Operating System - HP-UX

Simple shell script question

Craig A. Sharp — Thu, 20 Feb 2003 13:46:13 GMT

I think I am in brain lock :-)

I have a simple shell script:

db2 << EOF
CONNECT TO ISDEV
BACKUP DATABASE ISDEV TO /dev/rmt/2mnb WITH 2 BUFFERS BUFFER 1024
c
EOF

Here is what is supposed to happen

1. Issue the CONNECT TO ISDEV to the db2 command. This works fine.
2. Issue the BACKUP DATABASE ISDEV TO /dev/rmt/2mnb WITH 2 BUFFERS BUFFER 1024
to the db2 command. This works fine.

At this point, the db2 command returns the statement Press (c) to continue or (q) to quit.

I am trying to pass the c to the db2 command in order to answer the question but it is not working.

Any ideas?

Thanks,

Craig

Re: Simple shell script question

Hai Nguyen_1 — Thu, 20 Feb 2003 14:03:37 GMT

Craig,

Try this one:

db2 << EOF
CONNECT TO ISDEV
BACKUP DATABASE ISDEV TO /dev/rmt/2mnb WITH 2 BUFFERS BUFFER 1024

c
EOF

Note that I added a blank line right before the "c" line.

Hai

Re: Simple shell script question

John Palmer — Thu, 20 Feb 2003 14:04:25 GMT

Looks as though db2 is reading the reply from /dev/tty (your terminal connection) rather than from standard input.

Is there any way to stop it asking for confirmation?

If not, then you could use 'expect' to program this.

Regards,
John

Re: Simple shell script question

Craig A. Sharp — Thu, 20 Feb 2003 14:24:52 GMT

Thanks for the replies. The extra space did not work. I have also checked to see if we can disable the confirmation but no luck.

I have never used expect but the might be an idea to try.

Re: Simple shell script question

john korterman — Thu, 20 Feb 2003 14:28:28 GMT

Hi Craig,
have you tried piping the "c" character to your script, e.g.:
# echo "c" | `your_script`

The quoutes round your_script are back_quotes - try making a separate script with a content like above, although I admit it looks ugly.

regards,
John K.

Re: Simple shell script question

Dietmar Konermann — Thu, 20 Feb 2003 15:47:26 GMT

John's assumption that db2 reads directly from its controlling terminal may be right...

Probably you could tweak it using the attached small wrapper to detach your script from the terminal? Sometime application give up when there's no terminal. :)

Compile it, e.g. as setsid:

# cc -o setsid setsid.c

Then run your shell script from it.

# ./setsid yourscript.sh

Best regards... Dietmar

Re: Simple shell script question

Francisco J. Soler — Thu, 20 Feb 2003 17:40:41 GMT

Hi, Craig, could you issue a ^M affer the c like this.

.....
WITH 2 BUFFERS BUFFER 1024
c^M
EOF

remember: if you edit the file with vi, to put a ^M you must do it with a ^V^M

Frank.