How the heck... do i delete the sap* from my sandbox client xxx?

[former_member823327]

I have a client on a sandbox where all the power users are locked (ones that can unlock sap*). I already have the sapstar logon param set to zero, so now all i have to do is delete that user, on said client, on said instance, in table USR02. How the heck do i do this on a DB2 platform where the OS is integrated with the DB? If this were MSSQL - no prob.

Regards,

Mark

[former_member823327 · Accepted solution]

Well, getting closer i was able to at least execute the last statement in the PACE shell but received execution errors and after further research found out that i can execue the db2 command in the Q shell. Unfortunately im now getting CLI conversion errors which i can't make sense out of.

• CLI ERROR *****

SQLSTATE: 57017

NATIVE ERROR CODE: -332

Character conversion between CCSID 13488 and CCSID 65535 not valid.

This is a bizarre error to my point of view, either i can execute SQL or not?

Regards,

Mark

[thomas_obermeier · Accepted solution]

Hi Mark,

I can reproduce this if I run

CHGJOB CCSID(65535)

on my current job prior to starting qsh. By default SIDOFR and SIDADM have a Job CCSID of 500. Run

CHGJOB CCSID(500)

or, even better, logon as SIDOFR/SIDADM and retry. Don't forget to end QSH with F3 (not F12) to avoid using the same qsh session with the old settings again.

If it still fails, check your Job CCSID with

DSPJOB OPTION(*DFNA)

Regards,

Thomas