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