Cannot log on to AS400 due to stuck backup program V5R3 with IBM Client Access
Hi All,
We recently had a power failiure during our daily backup procedure (Yes outlasted our 30 min emergency ups) This inadvertantly caused the back to fail, now every time we try to log in we have message that sates "end of day processing please try later" then we come back to log in screen.
I can log in as QSECOFR and QSYSOPR also the account that initiated the backup (Only on console A0) all other users receive the message. I have ended all the jobs that relate to the backup using WRKACTJOB command, but still receive the message.
I read on a forum that you can run ENDSBS *ALL and then do system restart which might remove the system locks.
I am only keeping the system running for Historical data and the company has now moved to SAGE so as soon as I gain access will end the scheduled backup tasks.
Can anyone help with my problem, I'm a noob so would appreciate as much help as possible.
Software/Hardware used:
I SERIES V5R3, IBM client access, j'avantage web access
We recently had a power failiure during our daily backup procedure (Yes outlasted our 30 min emergency ups) This inadvertantly caused the back to fail, now every time we try to log in we have message that sates "end of day processing please try later" then we come back to log in screen.
I can log in as QSECOFR and QSYSOPR also the account that initiated the backup (Only on console A0) all other users receive the message. I have ended all the jobs that relate to the backup using WRKACTJOB command, but still receive the message.
I read on a forum that you can run ENDSBS *ALL and then do system restart which might remove the system locks.
I am only keeping the system running for Historical data and the company has now moved to SAGE so as soon as I gain access will end the scheduled backup tasks.
Can anyone help with my problem, I'm a noob so would appreciate as much help as possible.
Software/Hardware used:
I SERIES V5R3, IBM client access, j'avantage web access
ASKED:
January 15, 2010 9:27 PM
UPDATED:
January 19, 2010 1:42 PM
Answer Wiki:
"end of day processing please try later" is an in house program message to inform the users the system is unavailable. Contact your Developement staff as someone has to reset some sort of "flag" (dtaara) to allow login.
To see all answers submitted to the Answer Wiki: View Answer History.
1. the backup process set a value – probably in a data area.
2. your user profiles default to starting a program which checks this
2.1 DSPUSRPRF of one of the user profiles — check on inital program
3. if you have the source you can find out what data area needs the value changed
or
you can try to find it from the othe end — the backup program
and if you can run that backup program again .. it will reset the value.
hope this helps — give us feedback or send more questions.
Phil
I have tried re-running the backups and still other users cannot log on. There are 5 backups tue, wed, thur, fri and sat. I have come to the conclusion that I may have to run all of them until completion. I have two to complete.
The initial program in DSPUSRPRF for the user i can log on is *NONE, where as the users that fail are SOARGPL.
do you have any other suggestions
thanks for your previous help…
You will find you answer in program SOARGPL..
Look at the source and you will see either a comparison in that program or another program that is being called and returning a variable that is prompting the program to send the message to the user trying to signon.
please can you tell me how to open a program so that I can view it.
thanks
Somewhere on your system there should be source code for that program.
You can try DSPPGM SOARGPL and see where the souce was when the program was compiled.
Another option is to STRDBG SOARGPL. Depending on how the program was compiled, it may display the source.
If it is a CL program you can RTVCLSRC to get the source.
dsppgmref SOARGPL might show the files used, data areas used programs called by SOARGPL which might also lead us along.
Phil
Thanks for all your help. I looked at the program and realised that it is was not one of the daily backups but a special “Weekend backup” this was set in progress by our Accounts Manager.
The backup had failed half way through due to the initial powercut, now when I re run the correct backup as Phil had stated the flag has been lifted and all systems are go. Without looking at the progs though I would’nt have known it was the Weekend one!
so thanks again for all you support all systems GO!! Problem Solved.
regards
Milhouse