Decoding the "Friendly text" version of the nbemmcmd errorsdb output

[Luc_H]

Hi All,

We need to decode the output of the nbemmcmd -errorsdb command:

The fields we're interested in are the Status and Operation (and possibly what the String1 field is)

For example what does a Status 8196, 4412, or 5 mean. Also it would be handy to know what the corresponding operation number refers to.

Thanks in advance.
Luc.

Example output:
Allocation Key Allocation Name Media Name Drive Name Job ID Status Code Operation Media Server Name Data 1 Data 2 String 1 Timestamp
0  DLB022 IBM.ULTRIUM-TD3.047 0 15 1 dl440634 0 0 {38} Sat Sep 19 13:39:20 2009
0  DLB030 IBM.ULTRIUM-TD3.009 0 5 1 bkprod01 0 0  Fri Aug 21 12:13:07 2009
0  DLB030 IBM.ULTRIUM-TD3.009 0 4360 4 bkprod01 0 0  Fri Aug 21 12:26:11 2009
0  DLB030 IBM.ULTRIUM-TD3.013 0 8211 5 bkprod01 0 0  Sat Aug 22 05:49:02 2009
0  DLB030 IBM.ULTRIUM-TD3.014 0 4412 4 bkprod01 0 0  Sat Aug 22 15:15:36 2009
0  DLB030 IBM.ULTRIUM-TD3.014 0 24 2 bkprod01 0 0  Sat Aug 22 15:21:08 2009
0  DLB052 IBM.ULTRIUM-TD3.027 0 5 1 bkprod01 0 0  Fri Aug 21 11:10:42 2009
0  DLB052 IBM.ULTRIUM-TD3.012 0 5 1 bkprod01 0 0  Fri Aug 21 11:24:42 2009
0  DLB055 IBM.ULTRIUM-TD3.046 0 4374 4 dl440634 0 0  Tue Jul 14 16:13:50 2009
0  DLB090 IBM.ULTRIUM-TD3.020 0 5 1 bkprod01 0 0  Fri Aug 21 12:24:06 2009
0  DLB090 IBM.ULTRIUM-TD3.020 0 4360 4 bkprod01 0 0  Fri Aug 21 12:26:11 2009
0  DLB090 IBM.ULTRIUM-TD3.023 0 4412 4 bkprod01 0 0  Sat Aug 22 15:15:36 2009
0  DLB090 IBM.ULTRIUM-TD3.023 0 24 2 bkprod01 0 0  Sat Aug 22 15:21:24 2009
0  DLB091 IBM.ULTRIUM-TD3.045 0 4374 4 dl440634 0 0  Wed Jul 15 10:28:01 2009
0  DLB143 IBM.ULTRIUM-TD3.028 0 5 1 bkprod01 0 0  Fri Aug 21 11:04:41 2009
0  DLB143 IBM.ULTRIUM-TD3.021 0 5 1 bkprod01 0 0  Fri Aug 21 11:20:41 2009
0  DLB163 IBM.ULTRIUM-TD3.013 0 8196 5 bkprod01 0 0  Thu May 14 18:11:47 2009
0  DLB163 IBM.ULTRIUM-TD3.013 0 9 1 bkprod01 0 0  Thu May 14 18:26:07 2009
0  DLB165 IBM.ULTRIUM-TD3.015 0 5 1 bkprod01 0 0  Fri Aug 21 11:02:42 2009
0  DLB165 IBM.ULTRIUM-TD3.019 0 5 1 bkprod01 0 0  Fri Aug 21 11:18:42 2009
0  DLB167 IBM.ULTRIUM-TD3.009 0 8196 5 bkprod01 0 0  Tue May 19 11:51:59 2009
0  DLB167 IBM.ULTRIUM-TD3.009 0 9 1 bkprod01 0 0  Tue May 19 12:06:20 2009
0  DLB169 IBM.ULTRIUM-TD3.028 0 9 1 bkprod01 0 0  Thu May 14 18:22:48 2009
0  DLB177 IBM.ULTRIUM-TD3.014 0 9 1 bkprod01 0 0  Thu May 14 18:23:32 2009
0  DLB182 IBM.ULTRIUM-TD3.016 0 8196 5 bkprod01 0 0  Thu May 14 18:08:58 2009
0  DLB182 IBM.ULTRIUM-TD3.016 0 9 1 bkprod01 0 0  Thu May 14 18:23:33 2009
0  DLB183 IBM.ULTRIUM-TD3.024 0 8196 5 bkprod01 0 0  Wed May 13 18:06:40 2009
0  DLB183 IBM.ULTRIUM-TD3.024 0 15 1 bkprod01 0 0 {11} Wed May 13 18:06:47 2009
0  DLB186 IBM.ULTRIUM-TD3.018 0 9 1 bkprod01 0 0  Thu May 14 18:29:01 2009
0  DLB186 IBM.ULTRIUM-TD3.018 0 8196 5 bkprod01 0 0  Thu May 14 18:14:36 2009
 

[CRZ]

Near as I can tell, you're the first person in the history of NetBackup to ask us what those things mean.  And I am completely clueless.  All I can tell you is it relates to one of the nebulous ... SOMETHINGS ... making up one of the tables in the EMM database.

Also, it looks like another instance where we use null strings instead of "*NULL*" which mucks up the number of fields in a line depending on whether or not String 1 has a value or is empty.  The fact that it hasn't been caught to this point is probably another indicator that nobody's found this output useful enough to, at the very least, try to write an awk script around it.  ;)

If you really want this answer, it will probably take a support case - and probably some polite but persistent demands to get it escalated, perhaps all the way up to the developer level, because they're probably the only people who actually know what they've put into there. 

Sorry I don't have better news.

[Luc_H]

I sort of figured it might be this way.

It's a shame I'm no longer with Symantec, I could have just looked in the source code myself.

Thanks anyways.

[mph999]

Hi Luc,

Is that my ex favorite trainer ...  Martin H here - I'll look into it for you and report back ....


Martin