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

Comments