Skip to content

How to manually check the overall health of SPA?

How to manually check the overall health of SPA (In this example SPA14 i.e. mm014)

RUn below command as nz and you will get required details.

MyServer:/export/home/nz->ssh mm014 health -l all -f

system> health -l all -f
system: Critical
mm[1] : OK
mm[2] : OK
blade[1] : OK
blade[3] : OK
blade[5] : OK
blade[7] : OK
blade[9] : Critical
(SN#Y012UF2A90TN) Memory device 2, (DIMM 2) memory scrub failed
(SN#Y012UF2A90TN) Memory device 1, (DIMM 1) memory scrub failed
blade[11] : OK
blade[13] : OK
power[1] : OK
power[2] : OK
power[3] : OK
power[4] : OK
blower[1] : OK
blower[2] : OK
switch[1] : OK
switch[2] : OK
switch[3] : OK
switch[4] : OK

Error 5616 : The user is not authorized to grant or revoke role

Teradata user is not authorized to grant or revoke role.

Command Executed:
Ran below command by user login_user

grant my_role_name to my_user;

ERROR:

Executed as Single statement. Failed [5616 : HY000] The user is not authorized to grant or revoke role ‘my_role_name’.
Elapsed time = 00:00:00.011

STATEMENT 1: GRANT failed.
Explanation:

Only the user DBC, or a user granted this role WITH ADMIN OPTION, or a user with an
applicable role (current role or a role nested within it) that is granted a role WITH
ADMIN OPTION has the right to GRANT/REVOKE the role to/from another user or role.
Resolution:

Re-run the same command with different user who have required access or run below
grnat to your current user (which which you tried to run grant) below access (Run as
dbc or other poer user) :-

grant my_role_name to login_user with admin option;

Now, login back as login_user and re-run failed grant sql.