Is it possible to send OC reports without header/other format?

[pzzl321]

Hi@all,

i use IBM OC Version 8.1.5.000 and i ll generate a SQL-Report for our users.
Is it possible to change the output format? Always 3 rows is very ugly..

And i got another problem, if i use only db2 without OC i always get the hex value for filespaces like:
x'5C564D46554C4C2D657965676C6173732E7363632E756E692D7765696D61722E6465'
How can i get human readable informations?
I tried table nodes, nodesview, filespaces, filespaceview and always get the hex code -.-"

regards

 

[marclant]

Is it possible to change the output format?

Not to my knowledge.

How can i get human readable informations?

Try running your SQL queries from Spectrum Protect instead of DB2.

Also, even within Spectrum Protect, there's two columns for the filespace name, maybe you just picked the wrong column:

 

[pzzl321]

yeah currently we send report using q file and q node but our customer tell me they ll have a plain table formatted report.
NODE_NAME | FILESPACE_NAME | BSTART | BEND | SUCCESS

I tried every column in nodes, nodesview, filespaces and filespaceview and i cant get the plain filespace name >.< (Node Name, Backup Start, Backup End is no prob - only filespaces)

@OC the output is nice, but the email is horrible.. and i cant set up the report to generate only by backupfault

 

[marclant]

I tried every column in nodes, nodesview, filespaces and filespaceview

In DB2 yes. Try from Spectrum Protect.
select node_name,filespace_name,backup_start,backup_end from filespaces

 

[pzzl321]

="Try from Spectrum Protect.
select node_name,filespace_name,backup_start,backup_end from filespaces

jeah, we do it today - but i cant parse the detailed output from node/filespaces to a table. (for VMbackup and Filebackup)
and our customer dont want a email report in list - they want table, to get all information without scrolling

btw, sorry for my english - current report in attachment

 

[pzzl321]

ahh, never try select statement from dsmc.. maybe this ll do it for me. how can i organize the output in a table?
i redirect the output and it ll be displayed as list - but i ll get it working!

thx!

 

[marclant]

Use "-displaymode=table" with dsmadmc.