How to remove extra idle import process or export process (4320396)

Config was accidentally activated from the wrong Source Server and has been deactivated, but an extra unwanted import process is on the Target. The show command shows an import process idle and without a process id.

 

extra export process still points to the old target

Activating config from the wrong Server.

To remove the extra idle import process:

1. Shutdown sp_cop:
sp_ctrl> shutdown

2. Go to $SP_SYS_PRODDIR/bin:
./qview -i
qview>qsetup port#
qview>list
This will list all queues on the system.

Check for the extra WRITER (import process) for post queue , for an example:

idweb+P+o.idweb-o.opdb <------------------- Post Queue Name
subqueues range from 0 to 30
WRITER +PI+idweb+sp_mport+0x12345678c (xxx.x.xxx.66)
READER +PP+idweb+sp_opst+o.idweb-o.opdb
WRITER +PI+idweb+sp_mport+0x12345679c (xxx.x.xxx.76) <-------- extra process, verify ip

qview>deluser idweb+P+o.idweb-o.opdb +PI+idweb+sp_mport+0x12345679c
( delusr <queuename> <queue user> )
qview> list

Check to see if it is deleted.

 

To remove idle export process, check for extra READER for export queue, for an example

 

exp1-vip+X
WRITER +PR+o.SJACT_SPLEX+sp_ordr+o.SJACT_SPLEX
READER +PX+sjraccnt1-vip+sp_xport+0x0afc44a6 (10.252.68.166) --old IP
READER +PX+sjraccnt1-vip+sp_xport+0x0af0059a (10.240.5.154)

 

qview > deluser exp1-vip+X +PX+sjraccnt1-vip+sp_xport+0x0afc44a6

qview>exit

3. Restart sp_cop and issue 'Show', the extra idle import should be gone.