Reseting User ddic uflag parameter in Client 00 On Iseries as400 v5r4m0

[Former Member]

Hi

I am busy doing a homogenous system copy from my prd system to a new 4th system (for Migration possibilities). I know that at the end of my db copy it will prompt ,me to provide the ddic password. My source system ddic user id (prd) at the moment is locked. I intend backuping up the prd sytem tonight, but i need to reset user ddic first, as whatever gets backed up will come across.

Does anyone know how to reset the uflag paramter of ddic in client 000.

I have only two users in client 000 i.e ddic and sap* and i cant do anythign with sap* as it has no profiles attached to it.(security issue) I know how to do the unlock of the user in oracle i.e

Oracle

Update USR02 set UFLAG=0 where BNAME='DDIC' and MANDT=000.

Can anyone help on the as400 side.

[Former Member · Accepted solution]

I had a similar issue.

Turned out there was a code page mismatch.

before I started my SQL session I ran

CHGJOB CCSID(500)

and the SQL worked fine. My default code page had been 65535.

Hope this helps

Matt

[Former Member · Accepted solution]

Hi Matt,

not only YOURs is 65535 ... unfortunately IBM is using this by default for all NON-SAP users :-((

=> You should always use sidofr/adm or chgjob => 500

Regards

Volker Gueldenpfennig, consolut.gmbh

http://www.consolut.de - http://www.4soi.de - http://www.easymarketplace.de

[Former Member]

Hi

I apppreciate the feedback. but it does not like the command. It cgives us the ffg error:

Keyword SET not expected. Valid tokens: ADD DROP ALTER

CHECK UNIQUE FOREIGN PRIMARY CONSTRAINT.

Is it possible to try this on your as400

Thanks

[dorothea_stein]

Hi Morga,

it works perfectly fine for me...

It is a pure syntax error, so make sure that you don't have invalid characters in your command. Please send me a screen shot of the statement in SQLUTIL.

Also, you can find an excellent SQL reference at the IBM InfoCenter

http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/db2/rbafzmst02.htm

Best regards,

Dorothea

Message was edited by:

Dorothea Rink

[Former Member]

Hi Dorothea

Thanks for that info. I do have sqlutil on my system. Would you perhaps know how to use this command i.e to update the field (uflag) from 64 to 0

(From lock to unlock)

Would it be almost the same as below (not sure)

sqlutil Update USR02 set UFLAG=0 where BNAME='DDIC' and MANDT=000.

Much appreciated

[dorothea_stein]

Hi Morga,

almost. You'd call "SQLUTIL" first. Or in case QGPTOOLS is not in your library list, "QGPTOOLS/SQLUTIL". Then, a screen appears that lets you enter the actual SQL statement

Update USR02 set UFLAG=0 where BNAME='DDIC' and MANDT=000

That should do.

Best regards,

Dorothea

[dorothea_stein]

Hi Morga,

sorry, btw: MANDT is a character fields, so the statement would have to be

Update USR02 set UFLAG=0 where BNAME='DDIC' and MANDT='000'

Best regards,

Dorothea

[dorothea_stein]

Hi Morga,

If I understand correctly, you just need help how to issue SQL commands natively on the iSeries, is that right?

If so, that's how you'd proceed:

Sign on to the machine via green screen as user <sid>OFR and then type STRSQL. You'll then get as screen that allows you to enter the SQL statement like you suggested it for Oracle.

STRSQL is a product which does not come for free. So, if you do not have that installed, you could use SQLUTIL. SQLUTIL is free, but not per default on the system. (Search for library QGPTOOLS.)

In case you don't have it, read SAP note 68732 for more information of how to get it.

Hope that helps.

Best regards,

Dorothea