UNIX exit code 11


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers UNIX exit code 11
# 1  
Old 06-06-2014
UNIX exit code 11

We have a batch Unix process that runs during the day and it is getting an exit code 11 from Unix. It finishes a sqlplus step and gets the exit code 11 before it starts the next step. This used to happen once a year and now is happening more often (but not every time the process runs). We have investigated other processes that are running at that time but have not found anything. Any ideas?
# 2  
Old 06-06-2014
Well, a few clues would be useful here!
  • What have you tried so far?
  • Can we see the relevant portion of the script? Sanitise this if you need to take out anything sensitive
  • What OS and version?
  • What is the database version?
  • What is the SQL being called?
  • Why would the SQL return code 11?
  • Does it have WHENEVER SQLERROR EXIT FAILURE ; or similar?
  • What's the minimum you can reproduce this in?
Most importantly, what have you tried so far?


You have effectively asked me "Why has my car broken down" with no symptoms other that "It's stopped"

You will need to give us more to get something useful back.



Robin

Last edited by rbatte1; 06-06-2014 at 09:33 AM.. Reason: Line spacing and spelling
# 3  
Old 06-09-2014
Quote:
Originally Posted by msol
We have a batch Unix process that runs during the day and it is getting an exit code 11 from Unix.
I sense a slight misunderstanding here and before we go further i want to clear it up: "exit codes" are the result of a system call which ends a program and sets a certain exit code. It is common that an exit code of "0" indicates success and any non-zero exit code describes some or the other error condition. What this error condition might be is not standardized, so one program might give back "2" for "for not found" and another for something different.

The bottom line here is: not "UNIX gives back an exit code" but the application sets it itself upon exiting. UNIX just reports it. You could easily write a shell script yourself which sets any arbitrary exit code by using the "exit" keyword with some (signed short short) integer:

Code:
#!/bin/sh

i=125

# ... arbitrary code ....

exit $i

Run this and query the exit code:

Code:
# /path/to/script ; echo $?
125

You could enter any value -127-+127 and get the respective result. Therefore you need to consult the documentation of your application and find out what exit code "11" means. This depends entirely on the application you use and could be anything.

I hope this helps.

bakunin
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Exit code

can anyone tell what the exit status - 137 belongs in unix shell scripting. (3 Replies)
Discussion started by: ramkumar15
3 Replies

2. Shell Programming and Scripting

Exit code from piping in unix shell script

Hi , I have following code in my shell script : "$TS_BIN/tranfrmr" "${TS_SETTINGS}/tranfrmr_p1.stx" "${TS_LOGS}/tranfrmr_p1.err" | ( "$TS_BIN/cusparse" "${TS_SETTINGS}/cusparse_p2.stx" "${TS_LOGS}/cusparse_p2.err" | ( "$TS_BIN/tsqsort" "${TS_SETTINGS}/srtforpm_p3.stx"... (8 Replies)
Discussion started by: sonu_pal
8 Replies

3. Shell Programming and Scripting

exit from unix

Hi All, How can i exit from "unix"?. Looks silly , but still , i logged in to the unix box , then i did a "su - other user" , then " su - other user" , and i end up in the unix as a some 10th user. If i exist i will come to the previous user/account. I want to exit from unix in a single shot. ... (2 Replies)
Discussion started by: panyam
2 Replies

4. Shell Programming and Scripting

exit in unix

I am fixing a production issue. I am running out some problems with the exit command. This is how the code was in production if ; then echo 1 > $tmp/b1stat exit 1 else echo 0 > $tmp/b1stat fi I wanted to check for another condition and set a value 3 to the... (3 Replies)
Discussion started by: Muthuraj K
3 Replies

5. UNIX for Dummies Questions & Answers

How to capture exit code for a bg job

If I execute a job in background (in ksh or bash), how would I capture the exit code for that job? Thanks, - CB (1 Reply)
Discussion started by: ChicagoBlues
1 Replies

6. Shell Programming and Scripting

problem with exit code when piping

i am writing a script to perform some mysqldumps and gzip them. The problem I am running into is that if the user specifies a database that doesn't exist, the error the mysql engine produces is still piped into gzip, and the exit code returned is 0. If I don't pipe into gzip, an exit code... (4 Replies)
Discussion started by: bitoffish
4 Replies

7. Shell Programming and Scripting

where can I get exit code meanings?

I'm investigating strange behaviour on two boxes (Sun OS 5.10 and AIX 5.1) in ksh have used $? to get exit codes returned:- 137 and 34 where can I find what these mean? thank you (1 Reply)
Discussion started by: speedieB
1 Replies

8. UNIX for Dummies Questions & Answers

Where can I find a list of exit codes? (Exit code 64)

I'm receiving an exit code 64 in our batch scheduler (BMC product control-m) executing a PERL script on UX-HP. Can you tell me where I can find a list of exit codes and their meaning. I'm assuming the exit code is from the Unix operating system not PERL. (3 Replies)
Discussion started by: jkuchar747
3 Replies

9. Programming

Exit Code in HP-UX KSH.

In one of my programs another process is called using the system command e.g. lv_error = system("myproc"); where lv_error is declared as an int. myproc would be returning 0 for success and 1 for failure. e.g. if (success) { return(0); }else{ return(1); } When the return code... (3 Replies)
Discussion started by: mbb
3 Replies

10. Shell Programming and Scripting

All about exit code

Hi, I am working on Solaris 8 and the "intro" man page says, "Upon termination, each command returns two bytes of status, one supplied by the system and given the cause for termination, and (in the case of 'normal' termination) one supplied by the program. The former byte is 0 for normal... (2 Replies)
Discussion started by: cdin2
2 Replies
Login or Register to Ask a Question