on 09-08-2009 6:54 PM
When I schedule any job using dba calender the program used is
rsdbajob. For eg DBA:REORGCK_ALL_____@170000/2000 and
DBA:RUNSTAT_TAB_____@230000/2000 both use the same program rsdbajob.
How does the scheduler distinguish amongst the two ?
I thought may be using the variant but it also differs and is not
constant for a job. A new variant is created each time you create a job.i.e when i schedule the same job twice say
DBA:REORGCK_ALL_____@170000/2000 the jobs have different varients in
the form &0000000000023 and &0000000000024.
So my questions are:
1) how does the scheduler distinguish between reorg and runstats job which both run the same program rsdbajob ?
2) what is the use of the variant (&0000000000024) and why is a new one created each time ?
thank you.
RSDBAJOB checks the connectivity to the database instance using brconnect exe
for details on BRCONNECT
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please check this guide and you shall be able to find the difference.
Thanks
Rishi Abrol
Thank you but I think brconnect is specific to only oracle. I dont see the brconnect executable in my kernel directory. I am using db6 (ibm db2 ese v9.1 on aix).
Also the rsdbajob is the program that runs when u schedule any database maintanence job like runstats and reorg. What I wanted to understand was how does the scheduler know what to do as the same program is being executed ?
Rishi,
I could not find rsdbajob program in that guide or any details about the program. There is just general details about runstats and reorg.
My question is how does the scheduler distinguish between running a reorg versus a runstats when both jobs run the same program ?
Pls let me know.
thank you.
Hi
Do you have Planned ( Scheduled) job in DB13 Planning Calender?
From SE11 check the field names for SDBAP ( Database Planning Calender table). Short Text "Type of DBA action" is actually defined which DBA job it will do. If you have a periodic job then you can find Period values there. Other values are self-explanatory. I am confident that from SE11 you can make out the meaning of other fields.
Table SDBAC DBA Action Table.. i could not find any field called "Create Time" or Period there. So, I guess DB13 first read from SDBAP table.
No, it doesn't read from SDBAP
Note 564576 - Resetting the scheduling in transaction DB13
Note 642345 - DB6: Resetting DB13 scheduling
SDBAC
Note 859450 - Maintenance of the DB13-command table SDBAC
Note 918877 - Actions are missing in DB13 after upgrade to Oracle 10g
Note 1082088 - DB6: Errors in DBA Cockpit in Support Package 13
Hi Anjali,
I am in a scenario where CI & DB are on different servers. Scheduling through DB13 is ending in error SAPXPG.....
Hence I want to schedule it as a background job that will run from the DB server.
Can you pl tell me how to accomplish this ? I tried scheduling prog RSDBAJOB through se36, but returned error as there was no action parameter...
Regards,
Jitendra Mhalgi
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.