Important Updates to Cybersecurity Software

HelpSystems is updating the names of our cybersecurity software, including the Powertech product line. Don’t worry—the functionality of your products won’t change.

See the new names here > New, Simpler Names for HelpSystems Security Software.

--------------------

Catching Up on Processing when Data Queues are corrupt or unusable

Data queues, while very efficient, are prone to occasional damage. Sometimes this damage can render the data queue unusable. Checking the status of the data queue will show that it is damaged or corrupt.

If it is damaged or corrupt, the solution is to delete that data queue and stop and restart the Powertech Database Monitor jobs. Powertech Database Monitor will automatically re-create that data queue upon startup.

Listing the data queues:

To list the data queues and their status, you have the following options:

  • Option 12 from the DataThread Main Menu
    • Page down and you will see the data queues and the status of them. If they are white, they are working and have a status of ‘ok’.
    • If they are red, they are corrupt or damaged and you can put a ‘4’ next to that data queue to delete it. Powertech Database Monitor will recreate the data queues upon restart.
    • To restart:

Take Option 17 (Powertech Database Monitor Manager) from the Main Menu.

Enter the command ENDALL to end all the jobs in the Powertech Database Monitor SBS.

Enter the command STRMGR to restart those jobs and the data queue will be automatically rebuilt.

Once the Data queue has been re-created, the monitor job (IDT450) will automatically catch-up cleaning out the Data queues and copy the data to the data vault within DataThread.

Alternatively,

  • Enter the following command from the command line to list the data queues:

WRKOBJ OBJ(DATATHREAD/IDTLOGQ*) OBJTYPE(*DTAQ)

This will list the IDTLOGQ data queues A-G. Often an 8 will show text 'Object is Damaged '.  If so, select a 4 next to IDTLOGQ and press ENTER to delete it. DataThread will recreate the queues upon restart.

To restart:

Take Option 17 (Powertech Database Monitor Manager) from the Main Menu.

Enter the command ENDALL to end all the jobs in the Powertech Database Monitor SBS.

Enter the command STRMGR to restart those jobs and the data queue will be automatically rebuilt.

Once the Data queue has been re-created, the monitor job (IDT450) will automatically catch-up cleaning out the Data queues and copy the data to the data vault within DataThread.


Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: April 08, 2019