Link to home
Start Free TrialLog in
Avatar of it-rex
it-rex

asked on

AIX scheduled jobs and recent errors

We hav an AIX system that hosts our Oracle DB,yesterday we had few issues with the database;and here we suffer from huge lack of communication with SA team.

1-How can I check if there were any thing scheduled to run between 1am and 4am other than the crontab?
2-how to check the TSM run time?
3-how to check for system events/errors happened at a speceific time?
Avatar of H
H
Flag of United States of America image

You can also check the dbms_scheduler

connect to oracle database

SELECT * FROM DBA_SCHEDULER_JOBS;

Another check..
SELECT * FROM ALL_SCHEDULER_RUNNING_JOBS;

Open in new window

Displaying the Event Log

You can display the Windows® Event Log to understand the problem behind some device errors.

    In the Tivoli Storage Manager Console, select Launch. From the Administrative Tools window, open Event Viewer. Information on system events is displayed.
    Under the column labeled Source, look for events that are labeled with “AdsmScsi”.

    You can also use filtering to see just the events related to Tivoli Storage Manager. From the View menu, select Filter Events..., and set the filter to show events with event ID 11.
    Double-click on the event to get information about the date and time of the error, and detailed information. To interpret the data bytes that are shown in the Data field, use the appendix in the IBM Tivoli Storage Manager Messages that discusses device I/O errors.

Avatar of it-rex
it-rex

ASKER

@hollecar
Iam using AIX not windows.
Also I want to know what is scheduled on the Unix box other than crontab and oracle.
HI SO to clarify your question.

Are you are looking for the steps to review how Tivoli storage manager is scheduled on your unix box?
- You can still use the web/gui client to view TSM running on unix..
http://www.urz.uni-heidelberg.de/ADSM/ibmdoc.tsm42/html/sun/unixc/ans50011.htm


or

Are you wondering if there are pother 3rd party unix schedulers running on your unix box.
You need to have 'root' privileges to check the logs, for all of your questions.  For TSM log, you need to have TSM  Admin privilege.  

Other than Cron, is there any scheduling tool in place, like ca agent?

TSM client runtime is 'dsmc'.

syslog, errlog, tdpoerror.log,etc. are some of the logs you might have to take a look.
Avatar of it-rex

ASKER

what are the locations of
syslog, errlog, tdpoerror.log,
Default location is /var/syslog, but it could be configured to use something else.
To read errlog, use 'errpt' command.
Default tdpoerror.log, is "/opt/tivoli/tsm/client/oracle/bin/tdpoerror.log"
ASKER CERTIFIED SOLUTION
Avatar of woolmilkporc
woolmilkporc
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of it-rex

ASKER

thanks