Shell Programming and Scripting

Perhaps we could try the following variation:-

Code:

su - sybase -c "/var/tmp/db_tools <<EOT
13
0
EOT" >> logfile

Does that help?


Robin

Or, perhaps using printf in place of echo?

Hi,

No below also not working it throws "Script aborted......."

Code:

su - sybase -c "/var/tmp/db_tools <<EOT
13
0
EOT" >> logfile

Else can we change the original script as suggested earlier in the thread.
My request are as follows :-

Code:

su - sybase

Whenever executed "/var/tmp/db_tools"
it should always run option "13. Healthcheck <Validation> Summary"
after this "0. Exit"
atlast "quit"

We can edit the attached db_tools.

Thank You

Regards,
Madhur

Okay, let's try to do one thing at a time. Can you become user sybase and then run:-

Code:

echo "13\n0" | /var/tmp/db_tools

What output do you get then?


Do you have to CNTL-C to cancel it still? Perhaps scott's suggestion would work better:-

Code:

printf "13\n0" | /var/tmp/db_tools

Robin

Hi,

I used below

Code:

su - sybase
printf "13\n0" | /var/tmp/db_tools

Yes, I have to CNTL-C to cancel it.

Regards,
Madhur

Ctrl-C, or would Enter do? Try adding another \n after the 0. If that doesn't work, run the command manually and trace your steps.

Hi Scott,

Initially the below code works and shows the output.

Code:

printf "13\n0\n" | /var/tmp/db_tools

But once it displays -> All checks completed!

It again loops for input and displays menu.
I guess it not taking "0" as exit and keep on loop

Press <Return> to continue:
Select the action you want to perform:

1. Tempdb Setup Validation
2. Veritas QIO Validation
3. Sybase Error Logs Validation
4. File Validation
5. Sybase Database Space Usage Validation
6. Sybase Database & Device Usage Listing
7. Advanced Sybase DBA Tools
8. Sybase Diagnostics & Instrumentation Administration
9. Sybase Diagnostics & Instrumentation Reports
10. Examine Configurable Shared Memory Dump (CSMD) Setup
11. Sybase Backup Validation
12. Restore Individual or All Application Databases from DB Dumps
13. Healthcheck <Validation> Summary

0. Exit

Enter your choice:
^C
Script aborted.......


sybase@arr>

Regards,
Madhur

---------- Post updated at 09:36 PM ---------- Previous update was at 09:13 PM ----------

Hi,

This one works fine.

Code:

printf "13\n\n0\n\nEXIT\n" | /var/tmp/db_tools

But how to perform below

Code:

#!/bin/sh
su - sybase
printf "13\n\n0\n\nEXIT\n" | /var/tmp/db_tools
exit

OR

Code:

#!/bin/sh
su - sybase -c "printf "13\n\n0\n\nEXIT\n" | /var/tmp/db_tools"
exit

Regards,
Madhur