.st0{fill:#FFFFFF;}

IBM i Change Management – Using Mixed Case password in TURNOVER 

 March 10, 2021

By  NickLitten

UNICOM TURNOVER – Software Change Management System

Problem – TURNOVER uses an uppercase 10 character password by default

If you are thinking of changing your USRPRF(TURNOVER) password to anything – including a lowercase letter – then you just might want to read this!

Why should I read this and what is this bloke waffling about?” I can hear you think

If you have changed your IBM i system values to allow lower case password and you have changed the password on USRPRF(TURNOVER) to use lower or mixed case you might see the following error on *SYSOPR after attempting a distribution in TURNOVER.

TURNOVER crashes trying to set mixed case password in both CLIENT and GREEN SCREEN. The error message is:

* Data area TMIXEDPW in *LIBL not found.
Parameter 2 of function ENCRYPT_TDES not valid.
Argument 02 of function ENCRYPT_TDES not valid.

essage ID . . . . . . : CPD439A Severity . . . . . . . : 40
essage type . . . . . : Diagnostic
ate sent . . . . . . : 03/02/21 Time sent . . . . . . : 12:21:00

essage . . . . : Parameter 2 of function ENCRYPT_TDES not valid.
ause . . . . . : Parameter 2 specified in function ENCRYPT_TDES is not
valid for use for reason code 6. The reason codes and their meanings follow:
1 — Parameter must be a string constant.
2 — Parameter must be an integer constant.
3 — Parameter must be a numeric constant.
4 — Parameter’s length is too long.
5 — Parameter’s value is out of range.
6 — Parameter must be a valid CCSID.
7 — Parameter cannot be a parameter marker.
8 — Parameter’s data type is not supported by the built-in function.
9 — Parameter cannot reference a column with an active column mask since

Well, the problem is that TURNOVER by default has a 10 character (old AS.400/iSeries style uppercase password). Since most companies are now using longer passwords this is obviously a glaring problem. Luckily it’s fairly straightforward to fix:

Solution – Change TURNOVER CONFIG to allow mixed case passwords

You need to create a DATA AREA in the SOFTTURN product library called TMIXEDPW and it must be 4 characters with a value of *YES in it:

snug cbd discount coupon 15% off

20% Off with Coupon: NICKLITTEN

I highly recommend the SNUG CBD Tincture to help keep you in the zone when programming!

In Partnership with SNUG CBD - American readers get 20% off

CRTDTAARA DTAARA(SOFTTURN/TMIXEDPW) TYPE(CHAR) LEN(4) VALUE('YES') TEXT('Force TURNOVER to allow mixed case password')
IBM i Change Management - Using Mixed Case password in TURNOVER 1

Once you have created the password you can go and update the distribution password to match the remote password on your remote IBM i system:

Update password stored in TURNOVER

Go into TURNOVER 5250 and take option 11 – Distribution Menu

IBM i Change Management - Using Mixed Case password in TURNOVER 2

Option 6 – Override Network Distribution Method

IBM i Change Management - Using Mixed Case password in TURNOVER 3

Select your remote system and update

IBM i Change Management - Using Mixed Case password in TURNOVER 4

Now you can add your remote password in mixed case

NOTE: the value of “Mixed Case Password” will now show *YES which it retrieved from that data area:

IBM i Change Management - Using Mixed Case password in TURNOVER 5

NOTE: Don’t forget to check the remote system to make sure the USRPRF(TURNVOER) wasn’t disabled when you were trying to change the password before.

NickLitten


IBM i Software Developer, Digital Dad, AS400 Anarchist, RPG Modernizer, Shameless Trekkie, Belligerent Nerd, Englishman Abroad and Passionate Eater of Cheese and Biscuits. Nick Litten Dot Com is a mixture of blog posts that can be sometimes serious, frequently playful and probably down-right pointless all in the space of a day. Enjoy your stay, feel free to comment and remember: If at first you don't succeed then skydiving probably isn't a hobby you should look into.

Nick Litten

related posts:

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Get In Touch

Iā€™m always looking for awesome input, feedback and critique!

>