dbm-command file_operation

[lbreddemann]

Hi MaxDB collegues,

does anybody know how one can use

file_operation

in dbmcli so that it actually works?

As of [MaxDB Doku|http://maxdb.sap.com/doc/7_6/24/a967104c2d11d4aa1100a0c9430730/content.htm] it should be as easy as

file_operation BACKHIST OP=SHRINK LINES=10

to chop down the backuphistory to the most recent ten lines.

Unfortunately all I get (on 7.6.03 B15) is:

ERR

-24996,ERR_PARAM: wrong parameters

---

dbmcli on db760>file_operation BACKHIST OP=DELETE

ERR

-24996,ERR_PARAM: wrong parameters

Any idea anybody?

Thanks and KR Lars

[roland_mallmann · Accepted solution]

Hi Lars,

well, the thing is, the dbm command file_operation is only possible on very specific files (which our documentation doesn't reflect). Those files would be any files starting with atp or lc or any of the dba files in the DBAHIST subdirectory of the Rundirectory.

So it cannot be used for the usual analysis files like knldiag.err, dbm.knl or similar. I agree that the error message delivered by DBM is rather misleading.

Regards,

Roland

[lbreddemann · Accepted solution]

Hi Roland,

thanks for the clarification. Could you drop the docu team a line on it?

Perhabs a little enhancement with the error message would also be nice...

Thanks and best regards,

Lars

[Former Member]

Hi Lars,

it seems that there is a small error in your statement.

Please try

file_operation BACKHIST OP=SHRINK LINE=10

The help shows LINE as an option, not LINES.

Good luck

Christian

[lbreddemann]

Hi Christian,

thanks for your reply - but unfortunately it's not the misspelling... I tried that as well before (and pasted the wrong line into my question, yes ...:-/).

Thanks anyhow for the quick response.

Lars