Types of Jobs in DataStage

Server jobs

• Executed by the DataStage server engine
• Compiled into Basic
• Runtime monitoring in DataStage Director
• No parallel capability

List the tables in DB2 LUW & z/OS

List the tables in DB2 LUW

list tables for all

list tables for schema <schema_name>

or

select * from syscat.tables ;