473,382 Members | 1,389 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

Find DB2 job name from system tables in DB2 database

Hi,

I am basically a Microsoft SQL Server DBA. I am relatively new to DB2 database.

I would like to know if we can find out the name of the system table in DB2 database, which holds the list of all DB2 jobs that are present on particular DB2 database server. Usually system tables are the ones which are created and maintained internally by the database itself . (This is the concept in Microsoft SQL Server ). Also I would like to know the name of the system table which holds the schedules of jobs like system table msdb..sysjobhistory in MS SQL Server.
Usually in SQL Server, the list of all jobs is stored in a system table and if we run a SELECT query against the SYSTEM table, it tells the list of all jobs that are present on that SQL Server Instance. That system table name is sysjobs , which is present on the system database named msdb. So for example, it would be SELECT name FROM MSDB..SYSJOBS

Basically I would like to find out what is the name of the job in DB2 database which runs an UPDATE statement against our table TableA

Thanks in advance.
Mar 10 '10 #1
0 2353

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Richard Bailey | last post by:
Greetings. Today I was testing the sql backup/restore functions on our primary server. I was able to backup my database without any problems but when I tried to restore it, I received an error...
4
by: serge | last post by:
I tried all the INFORMATION_SCHEMA on SQL 2000 and I see that the system tables hold pretty much everything I am interested in: Objects names (columns, functions, stored procedures, ...) stored...
11
by: JoshuaF | last post by:
hello everyone i am very new to postgresql 7.3.3 and am using it on my mac G4 OS X and i am having some trouble which i hope you can help me out with some answers to my questions: 1.) How can I...
7
by: robert | last post by:
well, i can't remember being limited to 8 characters for something, except in the good ole days of M$-dos. now i find that DB2/390 has a 8 character limit on tablespace names?!?!?!?!? given...
4
by: John Bailo | last post by:
I have created several aliases to members using the CREATE ALIAS command, but I lost track of them. Now I want to see a catalog of all the aliases mapped to all members in a FILE. Is there a...
2
by: Josh | last post by:
Hi Guys, I have been stuck on this problem for several days now, i have a set of nested datagrids. Inside the second datagrid i have a dropdown list, a textbox and a label. I want the textbox...
6
by: Becker | last post by:
Very simple, I have a datagrid on a windows form. I load some rows in it. I click a column header and it sorts ascending. I click it again it sorts descending. This is great, but what I want to...
17
by: Justin Emlay | last post by:
I'm hopping someone can help me out on a payroll project I need to implement. To start we are dealing with payroll periods. So we are dealing with an exact 10 days (Monday - Friday, 2 weeks). ...
4
by: Agnes | last post by:
Sorry for my question again. My form got the previous , next , top,bottom button and allow the user to move the records . Now, the table got 500 records, I need to do a features for the user to...
1
by: marcnz | last post by:
I have been charged of creating a coldfusion web site for our company. Our database has a ms sql 2005 backend and ms access frontend. Almost all tables are linked tables with the SQL database,...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.