Combine 2 SQL tables.

[tsmlover]

How to combine 2 different SQL tabels

i.e. select nodes.node_name, events.result from events,nodes

I want to combine events and nodes table together to gather plateform_name information from Nodes table and backup status information from Events table

i have tsm 6.1,


does any one did this thing ....

Thanks

 

[domino]

show the example for "infos about schedules and associations"

http://www.tsmguide.co.cc/p/database-and-recovery-log-list-all.html

 

[tsmlover]

I already browse thru that website but i didnt find my answer I need to run this script

select events.node_name,events.status,events.result,events.actual_start,nodes.platform_name from events events, nodes nodes where events.node_name=nodes.node_name order by events.node_name,events.status,events.result,events.actual_start,nodes.platform_name

but its not working ..

 

[ChrisRees]

Hi.

You have a space on the first line and last line event s.actual_start

It works for me on TSM 5.5.4

What error do you get when you run it ?

Cheers

 

[tsmlover]

yes the script is working with 5.5 but on 6.1 it gives me the below error.....

select events.node_name,events.status,events.result,events.actual_start,nodes.platform_name from events events, nodes nodes where events.node_name=nodes.node_name order by events.node_name,events.status,events.result,events.actual_start,nodes.platform_name
ANR0162W Supplemental database diagnostic information: -1:42S22:-206 ([IBM][CLI Driver][DB2/AIX64] SQL0206N "NODES.NODE_NAME" is not valid in the context where it is used.
SQLSTATE=42703
).
ANR2940E The command 'select events.node_name , events.status , events.result , events.actual_start , nodes.platform_name from events events , NODESVIEW NODESVIEW where
events.node_name = nodes.node_name order by events.node_name , events.status , events.result , events.actual_start , nodes.platform_name ' contains an unknown SQL column name.
ANS8001I Return code 3.