Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 367
  • Last Modified:

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?
0
it-rex
Asked:
it-rex
  • 6
  • 3
  • 2
  • +1
1 Solution
 
HDatabase AdministratorCommented:
You can also check the dbms_scheduler

connect to oracle database

SELECT * FROM DBA_SCHEDULER_JOBS;

0
 
HDatabase AdministratorCommented:
Another check..
SELECT * FROM ALL_SCHEDULER_RUNNING_JOBS;

Open in new window

0
 
HDatabase AdministratorCommented:
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
HDatabase AdministratorCommented:
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.

0
 
it-rexAuthor Commented:
@hollecar
Iam using AIX not windows.
Also I want to know what is scheduled on the Unix box other than crontab and oracle.
0
 
HDatabase AdministratorCommented:
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.
0
 
balasundaram_sCommented:
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.
0
 
it-rexAuthor Commented:
what are the locations of
syslog, errlog, tdpoerror.log,
0
 
HDatabase AdministratorCommented:
0
 
balasundaram_sCommented:
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"
0
 
woolmilkporcCommented:
dsmc q sched # TSM BA scheduling info

dsmc q options '*LOGNAME'  # all TSM BA logfiles

lssrc -ls syslogd # syslog file locations

errpt # Errlog

alog -t console -o  # Console messages

alog -t boot -o  # Startup messages

wmp
0
 
it-rexAuthor Commented:
thanks
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 6
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now