Process Number: 210	Revision Date: 8/4/2003 8:25:02 AM
Revision #: 19	Back | Access Password:

Refresh Datatel Account

Office Responsible:

DCS - District - Computing Services

Process Type:

internal

Position Title:	Datatel System Administrator		Author:	bnoble
Cross Trained Staff:		Manager:	rkeith	Vice Pres.:

Timeline (Deadlines or Time-Constraints) :

As needed, generally prior to loading patches

What must be done before this process is started:

Datatel system backup

Which processes are waiting for this process:

Source documents or communication with information needed for this process:

What is the end-result of this process, or the hand-off

What steps must be taken independent of the computer system (Manual Process)

Notify Datatel users of the date and time of the account refresh, and that they must not be logged in at that time.

Which steps must be taken on a computer (Electronic Process):

1. Shut down TReg and WebReg. 2. Log in to the sb2 server as "datatel". 3. From the unix prompt login as "root". 4. Check for any users currently using UniData with the command "ps -fe | grep udt". 5. Kill all such processes using the "kill" command. 6. Lock out all users except "datatel" with the command "chmod 700 /datatel". 7. Repeat step 4 to verify that no users logged in before you locked them out. 8. Remove the test account with the command "rm -rf /datatel/work/coltest" or the development account with the command "rm -rf /datatel/development/coldev". 9. Copy the live account to the test account with the command "cp -rp /datatel/live/collive /datatel/work/coltest" or to the development account with the command "cp -rp /datatel/live/collive /datatel/development/coldev". 10. Log out of "root" and verify that you are logged in as "datatel" with the "whoami" command. 11. Start UniData in the account you are refreshing. 12. Change all occurrences of "/live/collive" to "/work/coltest" or to "/development/coldev" in fields 2 and 3 of all VOC records. 12a. SELECT VOC WITH F2 LIKE …/live/collive… OR F3 LIKE …/live/collive… 12b. ED VOC 12c. CD # 12d. =FIX 2#CU2./live/collive./work/coltest#FI#=FIX or =FIX 2#CU2./live/collive./development/coldev#FI#=FIX 12e. =FIX 13. Change all occurrences of "/live" to "/work" or to "/development" in fields 2 and 3 of all VOC records. 14. Change all occurrences of "/release/COLL17" to "/development/CDEV17" in fields 2 and 3 of all VOC records. (The test and development accounts have the same release/install account.) 15. Update the UT.VOC.REMOTE.XREF field in every record of each appl.VOC file using the paragraph "S02.FIX.APPL.VOCS". 16. Update field 2 of the MENU.HEADER record in each appl.PARMS file. The eight applications are UT, CORE, HR, CF, ST, XST, TOOL, and CCVT. 17. Verify that the refreshed account is working. 18. Unlock the users with the command "chmod 770 /datatel". 19. Restart TReg and WebReg.

Related Documents to Process (e.g. Datatel documentation, Government code books, etc.)

Notes (Cautions, suggestions for improvement, etc.)

This process is generally, but not by necessity, run immediately prior to loading patches into the respective account. Datatel account directories: live account: /datatel/live/collive test account: /datatel/work/coltest development account: /datatel/development/coldev