Check the Status of Nightly Jobs on IXP and their Good Execution

Asset ID:	1-71-2018664.1
Update Date:	2015-07-13
Keywords:

Solution Type Technical Instruction Sure

Solution 2018664.1 : Check the Status of Nightly Jobs on IXP and their Good Execution

Related Items


Oracle Communications Performance Intelligence Center (PIC) Software

Related Categories


PLA-Support>Sun Systems>CommsGBU>Global Signaling Solutions>SN-SND: Tekelec PIC

Each night, an oracle job runs several tasks on IXP to ensure the good performances and Database space management. Here are described steps to verify whether the various operations were correctly completed or not, when there is a suspicion on "nightly jobs" status.

In this Document

Goal

Solution

Verify the content of the nighlty jobs log files

Verify through Oracle Enterprise Manager

References

Created from <SR 3-10843733670>

Applies to:

Oracle Communications Performance Intelligence Center (PIC) Software - Version 9.0.3 and later
Tekelec

Goal

Verify the good status of IXP nightly jobs to keep good performances of the system.

Solution

Verify the content of the nighlty jobs log files

Connect on IXP and check that jobs were completed for last period (current day early in the morning) or on a longer period if needed:

[root@ixp0001-1a ~]# tail -f /var/TKLC/log/ixp/IXP_NIGHTLY_JOB.log
16/06/2015 02:00:03 DEBUG IXP_NIGHTLY_JOB Begin
16/06/2015 02:00:03 DEBUG IXP_ACTIVE_PURGE Begin
16/06/2015 02:02:58 DEBUG IXP_ACTIVE_PURGE End
16/06/2015 02:02:58 DEBUG IXP_ADD_PARTITIONS Begin
16/06/2015 02:03:19 DEBUG IXP_ADD_PARTITIONS End
16/06/2015 02:03:19 DEBUG IXP_GLOBAL_STATS Begin
16/06/2015 02:27:34 DEBUG IXP_GLOBAL_STATS End
16/06/2015 02:27:34 DEBUG IXP_COMPRESSION Begin
16/06/2015 02:27:34 DEBUG IXP_COMPRESSION End
16/06/2015 02:27:34 DEBUG IXP_NIGHTLY_JOB End

Each job has also a dedicated log file that could be checked in case of issue:

/var/TKLC/log/ixp/IXP_ACTIVE_PURGE.log
/var/TKLC/log/ixp/IXP_ADD_PARTITIONS.log
/var/TKLC/log/ixp/IXP_COMPRESSION.log
/var/TKLC/log/ixp/IXP_GLOBAL_STATS.log

It is important to notice that all logs should display a normal activity without error message.

It can occur that IXP_COMPRESSION was not completed. This should not be considered as abnormal during the weekly maintenance window. This job generally completes during weekend maintenance window as it is longer.

Verify through Oracle Enterprise Manager

A check can be done also by using Oracle EM and/or the various available logs:

Connect on Oracle EM (connected as administrator), and verify from menu: Server --> Orale Scheduler --> Jobs.

IXP_NIGHTLY_JOB is present in the list.

Scheduler job screenshot

Click on the link IXP_NIGHTLY_JOB to display the detail of the activity.

Nightly_Jobs_execution_list

References

<NOTE:1910661.1> - Steps to Reduce Space Utilization of DATA_CDR or DATA_IND Tablespace Below 90%.

Attachments

This solution has no attachment