Sponsored Content
Top Forums Shell Programming and Scripting how do i execute nohup and background job inside the korn script for db2 Post 302602963 by rams82 on Tuesday 28th of February 2012 07:37:34 PM
Old 02-28-2012
It is not working ,Pls see the error


DB21018E A system error occurred. The command line processor could not
continue processing.
DB21018E A system error occurred. The command line processor could not
continue processing.
DB21018E A system error occurred. The command line processor could not
continue processing.
DB21018E A system error occurred. The command line processor could not
continue processing.
DB21018E A system error occurred. The command line processor could not
continue processing.
DB21018E A system error occurred. The command line processor could not
continue processing.



load_cursor_stmt()
{
ls /db/admin/ddl/rmn01000/load_cursor*.sql|while read file
do
nohup db2 -tvf "$file" &
done

}
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

unable to execute background job

I am unable to execute the below command in background. Plz suggest. #> ./test input >out & 913618 + Stopped (SIGTTIN) ./test input >out & Suresh (1 Reply)
Discussion started by: suresh3566
1 Replies

2. Shell Programming and Scripting

Execute Script using nohup and &

Hi all, I have one script test.sh for which I pass two arguments. In the same script I need to submit this script in background using nohup. My script like this and it is working in HP-UX os but not Solaris. #! /bin/sh if then MTR_PID=$$ export MTR_PID echo "test.sh $1 $2... (3 Replies)
Discussion started by: sridhar_423
3 Replies

3. Shell Programming and Scripting

Unix Korn Shell script on Solaris to DB2 UDB LUW database

I am rather new to korn shell scripting and attempting to write a Unix script that would detach, attach a range partition table in DB2 UDB LUW database. This would be a job scheduled in control M that reads in an input file with 5 parameters passed to it from the application. I don't have much... (1 Reply)
Discussion started by: tjhanso
1 Replies

4. UNIX for Dummies Questions & Answers

nohup - sub job in script not executing until I exit

My job is launched using this command: I'm at home and having VPN drops so I used nohup and background. nohup perf_mon -c rating_4_multi,cfg & The main script is PID 26119, and the sub task under it is 26118 which is not running - just sits there. 26119 runs forever but nothing else runs. I... (2 Replies)
Discussion started by: ido1957
2 Replies

5. Shell Programming and Scripting

Using ssh to execute a remote script in the background

Help please!! I want to use ssh to execute a remote exe and while it's running I want to query for the process ID of the exe (2 different ssh commands) 1. sshpass -p "<passwd>" ssh -f -o UserKnownHostsFile=/dev/null -o StrictHostKeyChecking=no root@<ipaddress> nohup /tmp/mmds_asyn & 2.... (0 Replies)
Discussion started by: rvompoluTMW
0 Replies

6. Shell Programming and Scripting

How to pass tablenames from a file to shell script to execute create statement in DB2

Hi, I am new to Shell Scripting, and I need to create nicknames for 600 tables in db2. I have the file names in a text file and i have to pass these table names to a shell script create nicknames in db2. Can some one please help me in this regard. (1 Reply)
Discussion started by: kamalanaatha
1 Replies

7. Shell Programming and Scripting

Need help in listing directories inside korn shell script

Hi All, I need to loop through each item in current path, if it is a direcotry do soemthing, if its a file jsut skip it and move to next item in loop. Tried if test ! -d $i then echo "The current item $i is not a directory" continue fi This doesnt seems to be working .... (8 Replies)
Discussion started by: justchill
8 Replies

8. Shell Programming and Scripting

How to execute korn shell script from different directory

Guy's , I need to run korn shell script from different directory, usually I run the script using ./details.ksh in the same directory but now I need to run the file and process details using awk code. Now I am running the script this way but with no luck Directory = home/users/work ... (3 Replies)
Discussion started by: James_Owen
3 Replies

9. Shell Programming and Scripting

Nohup inside shell script

Hi, I want to run another script inside shelll script in nohup mode. let explain. under the same folder ,I have two scripts scrone.sh scrtwo.sh In scrone.sh if then nohup ./scrtwo.sh & echo " Script two has been run correctly" else echo " Exiting from the script" fi If... (3 Replies)
Discussion started by: ckchelladurai
3 Replies

10. Shell Programming and Scripting

Korn Shell script in stopped state while running in background

Hi, I want to run a shell script in background . but its going to stopped state $ ksh cat_Duplicate_Records_Removal.ksh & 8975 $ + Stopped (tty output) ksh cat_Duplicate_Records_Removal.ksh & why is this happening? Also could anyone please tell me what is a stopped... (12 Replies)
Discussion started by: TomG
12 Replies
psradm(1M)                                                System Administration Commands                                                psradm(1M)

NAME
psradm - change processor operational status SYNOPSIS
psradm -f | -i | -n | -s [-v] [-F] processor_id psradm -a -f | -i | -n | -s [-v] [-F] DESCRIPTION
The psradm utility changes the operational status of processors. The legal states for the processor are on-line, off-line, spare, faulted, and no-intr. An on-line processor processes LWPs (lightweight processes) and can be interrupted by I/O devices in the system. An off-line processor does not process any LWPs. Usually, an off-line processor is not interruptible by I/O devices in the system. On some processors or under certain conditions, it might not be possible to disable interrupts for an off-line processor. Thus, the actual effect of being off-line might vary from machine to machine. A spare processor does not process any LWPs. A spare processor can be brought on-line, off-line or to no-intr by a privileged user of the system or by the kernel in response to changes in the system state. A faulted processor is identified by the kernel, which monitors the behavior of processors over time. A privileged user can set the state of a faulted processor to be on-line, off-line, spare or no-intr, but must use the force option to do so. A no-intr processor processes LWPs but is not interruptible by I/O devices. A processor can not be taken off-line or made spare if there are LWPs that are bound to the processor unless the additional -F option is used. The -F option removes processor bindings of such LWPs before changing the processor's operational status. On some architectures, it might not be possible to take certain processors off-line or spare if, for example, the system depends on some resource provided by the processor. At least one processor in the system must be able to process LWPs. At least one processor must also be able to be interrupted. Since an off-line or spare processor can be interruptible, it is possible to have an operational system with one processor no-intr and all other processors off-line or spare but with one or more accepting interrupts. If any of the specified processors are powered off, psradm might power on one or more processors. Only superusers can use the psradm utility. OPTIONS
The following options are supported: -a Perform the action on all processors, or as many as possible. -f Take the specified processors off-line. -F Force the transition to the additional specified state. Required if one or more of the specified processors was in the faulted state. Set the specified processors to faulted, if no other transition option was specified. Forced transitions can only be made to faulted, spare, or off-line states. Administrators are encouraged to use the -Q option for pbind(1M) to find out which threads will be affected by forced a processor state transition. -i Set the specified processors no-intr. -n Bring the specified processors on-line. -s Make the specified processors spare. -v Output a message giving the results of each attempted operation. OPERANDS
The following operands are supported: processor_id The processor ID of the processor to be set on-line or off-line, spare, or no-intr. Specify processor_id as an individual processor number (for example, 3), multiple processor numbers separated by spaces (for example, 1 2 3), or a range of processor numbers (for example, 1-4). It is also possible to combine ranges and (indi- vidual or multiple) processor_ids (for example, 1-3 5 7-8 9). EXAMPLES
Example 1: Setting Processors to off-line The following example sets processors 2 and 3 off-line: % psradm -f 2 3 Example 2: Setting Processors to no-intr The following example sets processors 1 and 2 no-intr: % psradm -i 1 2 Example 3: Setting Processors to spare The following example sets processors 1 and 2 spare, even if either of the processors was in the faulted state: % psradm -F -s 1 2 Example 4: Setting All Processors on-line % psradm -a -n Example 5: Forcing Processors to off-line The following example sets processors 1 and 2 offline, and revokes the processor bindings from the processes bound to them: % psradm -F -f 1 2 EXIT STATUS
The following exit values are returned: 0 Successful completion. >0 An error occurred. FILES
/etc/wtmpx Records logging processor status changes ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWcsu | +-----------------------------+-----------------------------+ SEE ALSO
pbind(1M), psrinfo(1M), psrset(1M), p_online(2), processor_bind(2), attributes(5) DIAGNOSTICS
psradm: processor 4: Invalid argument The specified processor does not exist in the configuration. psradm: processor 3: Device busy The specified processor could not be taken off-line because it either has LWPs bound to it, is the last on-line processor in the sys- tem, or is needed by the system because it provides some essential service. psradm: processor 3: Device busy The specified processor could not be set no-intr because it is the last interruptible processor in the system, or or it is the only processor in the system that can service interrupts needed by the system. psradm: processor 3: Device busy The specified processor is powered off, and it cannot be powered on because some platform-specific resource is unavailable. psradm: processor 0: Not owner The user does not have permission to change processor status. psradm: processor 2: Operation not supported The specified processor is powered off, and the platform does not support power on of individual processors. SunOS 5.10 17 Aug 2004 psradm(1M)
All times are GMT -4. The time now is 09:27 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy