Hey,
just played around to get reporting data out of TSM v6.3.4.200 using MS Excel 2010 ODBC connection to the DB2 database.
The connectivity works fine, but for some tables the result reported back to excel is just empty (for example: admin_schedules or scripts table). On a v5.x TSM server the corresponding queries did report data back. Are there any basics i missed on this topic to get the desired data back from DB2 ? Sometimes there is just 1 or 2 colums missing (like the filespace name if querying the filespaces or filespaceview table). Appears pretty strange to me at a first step. I use the ODBC client v9.7fp8 for this.
Any help is very appreciated. . . .
Thanks a lot
Trebron
just played around to get reporting data out of TSM v6.3.4.200 using MS Excel 2010 ODBC connection to the DB2 database.
The connectivity works fine, but for some tables the result reported back to excel is just empty (for example: admin_schedules or scripts table). On a v5.x TSM server the corresponding queries did report data back. Are there any basics i missed on this topic to get the desired data back from DB2 ? Sometimes there is just 1 or 2 colums missing (like the filespace name if querying the filespaces or filespaceview table). Appears pretty strange to me at a first step. I use the ODBC client v9.7fp8 for this.
Any help is very appreciated. . . .
Thanks a lot
Trebron
