CNSSUPV start: All Interactive Partitions are busy!! in Teradata
Problem:
# cnsterm 6
Attempting to connect to CNS...Completed.
Hello
Input Supervisor Command:
> start ferret
start ferret
CNSSUPV start: All Interactive Partitions are busy!!
at Tue Feb 19 10:51:50 2019
Input Supervisor Command:
Solution:
All cnsterm interactive partitions are busy due to already running processes. Runing the cnscim -s command shows all the cnsterm screens that are running a process and you can stop the process.
# cnscim -s
CNS Screens
Screen 1 -- checktable
active=True, enabled fkeys=2347, help level=0,
nostop=True, reading=True, hide=True
Screen 2 -- checktable
active=True, enabled fkeys=2347, help level=0,
nostop=True, reading=True, hide=True
Screen 3 -- qrysessn
active=True, enabled fkeys=, help level=0,
nostop=False, reading=True, hide=True
Screen 4 -- rcvmanager
active=True, enabled fkeys=, help level=0,
nostop=True, reading=True, hide=True
Screen 5 -- DBS I/O
active=True, enabled fkeys=, help level=0,
nostop=False, reading=False, hide=False
Screen 6 -- SUPERVISOR
active=True, enabled fkeys=, help level=0,
nostop=False, reading=True, hide=False
You can stop the process by logging into cnsterm 6 and entering the command " stop screen number " or logging to the screen number and use command quit to stop the process.
Example:
Option 1:
# cnsterm 6
Attempting to connect to CNS...Completed.
Hello
Input Supervisor Command:
> stop 4
Option 2:
You can stop the ferret process by logging into the cnsterm screen number where ferret is running and enter " quit "
# cnsterm 4
> quit;
In some cases Option 1 might not work then stop the process using option 2.
Example:
# cnsterm 6
Attempting to connect to CNS...Completed.
Hello
Input Supervisor Command:
> stop 1
stop 1
CNSSUPV: the program cannot be stopped
> ^C
# cnsterm 1
Enter a command, "QUIT;", "HELP;" or F7 for interactive help:
> quit;
quit;
CheckTable terminated.
> ^C