5 replies to this topic

[UxSteF]

Hi all,

I've a question about maintenance procedure on Dollar Universe 5.3.3.
I run a IU_WMNT uproc every week-end with theses parameters :

UXKEEP_JOB_LOG : 30
UXARCHIVE : %UXDIR_ROOT%\archive
UXAREA : APP INT SIM EXP
UXARC_JOB_LOG : 2

Even if I choose 30 days keeping execution jobs Dollar Universe always just keep 7 days of job log in execution panel and I wonder why.
More, if I take a look at D:\APPL\universe\UBIPRD\exp\log I can just see ".inp" and ".out" files for process older than 2 days , as I understand so it archive just the log files older than 2 days but keep the ".inp" & ".out" files.

Does someone can confirm this and know why graphical console shows just 7 days of execution even if the UXKEEP_JOB_LOG is setup to 30 ?

Thanks by advance for your help.

[men]

Hi,

Just part of the answer I'm afraid, as I don't know what IU_WMNT exactly does.

I guess that variable UXKEEP_JOB_LOG is used to define how long the job log files remain available - now this can be in the archive and not the original folder, and that you keep 2 days before archiving them(hence the UXARC_JOB_LOG value), bit I can't tell for sure.

But it clearly does not relate to how long the corresponding record sin the execution panel remain - this is handled by IU_PUR or by the continuous purge, and is obviously set to 7. Depending on the number of jobs that run daily, you should be very careful in increasing the number of days kept in the execution panel if ever you feel like doing so, as this may impact response time and disk usage.

About the ".inp" and ".out" files you find, do you know what creates them and what is their content? Are you submitting jobs for a third party software via one of Orsyp's managers for Dollar Universe?

Michel

[UxSteF]

Hi,

The IU_WMNT has been installed when ORSYP consultant setup Dollar UNiverse 5.3.3 in our company.

This is part of a global maintenance session (IU_WMNT) that contains also Export objects, full backup, reorganisation, ect
The head part of IU_WMNT script is the following :

@ECHO OFF

REM ###=========================================================================
REM #@(#) OBJECT: Purge execution logs
REM #@(#) OBJET: Purge des logs d'execution
REM #@(#)
REM #@(#) VERSION: 1.0.3
REM #@(#)
REM #@(#) AUTHOR: ORSYP Professional Services
REM #@(#) AUTEUR
REM #@(#)
REM #@(#) CREATION DATE: 2007/11/15
REM #@(#) DATE DE CREATION
REM #@(#)
REM #@(#) MODIFICATIONS:
REM #@(#) 1.0.0 -> 1.0.1: 2008/04/23 -- ARY -- Translated in French
REM #@(#) -- Traduit en francais
REM #@(#)
REM #@(#) VALIDATIONS:
REM #@(#) 1.0.1: 2008/04/23 -- ARY
REM #@(#) MODIFICATIONS:
REM #@(#) 1.0.2: 2008/07/25 -- SBZ -- Only archives logs older than
REM #@(#) UXARC_JOB_LOG
REM #@(#) -- Archive seulement les fichiers
REM #@(#) plus ancients que UXARC_JOB_LOG
REM #@(#) MODIFICATIONS:
REM #@(#) 1.0.3: 2008/08/25 -- ARY -- Only archives logs older than
REM #@(#) UXARC_JOB_LOG
REM #@(#) -- Archive seulement les fichiers
REM #@(#) plus ancients que UXARC_JOB_LOG
REM ###=========================================================================

Entire script is attached.
We have no IU_PUR uproc schedule today, so the execution panel should be done form elsewhere.

Do you know if I can download somewhere the "official" maintenance uprocs for Dollar Universe 5.3.3 (with classic IU_PUR)?


For the "inp" & "out" files :
Yes I use the PeopleSoft Manager 2.2 for Dollar Universe.

"inp" file contain the following information as example :
PRCSINSTANCE=7520
RUNSTATUS=9

(Peoplesoft Status I can imagine)

"out" contains the command line send from Dollar Universe to PeopleSoft :
(Tue Mar 24 12:20:45 2009
) command [e:\PSFT\PSV9EMEA\bin\sqr\ORA\BINW\sqrw d:\APPL\universe\UBIPRD\exec\uxpsoft8\uxstrpsoft.sqr SYSADM/[password]@PSV9EMEA -Ie:\psft\psv9emea\sqr\,d:\appl\universe\ubiprd\exec\uxpsoft8\ -Fd:\APPL\universe\UBIPRD\exp\log\ -Ed:\APPL\universe\UBIPRD\exp\log\Psoft_ERPDBEMEA_X_PSF_TEST_0000015.err -Od:\APPL\universe\UBIPRD\exp\log\Psoft_ERPDBEMEA_X_PSF_TEST_0000015.log -debug -ZIFe:\psft\psv9emea\sqr\pssqr.ini -XCB -XMB AEMINITEST "Application Engine" AUDIT EXPLOIT PSV9EMEA]
(Tue Mar 24 12:20:46 2009
) command [e:\PSFT\PSV9EMEA\bin\sqr\ORA\BINW\sqrw d:\APPL\universe\UBIPRD\exec\uxpsoft8\uxsynpsoft.sqr SYSADM/[password]@PSV9EMEA -Ie:\psft\psv9emea\sqr\,d:\appl\universe\ubiprd\exec\uxpsoft8\ -Fd:\APPL\universe\UBIPRD\exp\log\ -Ed:\APPL\universe\UBIPRD\exp\log\Psoft_ERPDBEMEA_X_PSF_TEST_0000015.err -Od:\APPL\universe\UBIPRD\exp\log\Psoft_ERPDBEMEA_X_PSF_TEST_0000015.log -debug -ZIFe:\psft\psv9emea\sqr\pssqr.ini -XCB -XMB 7520 d:\APPL\universe\UBIPRD\exp\log\Psoft_ERPDBEMEA_X_PSF_TEST_0000015.inp]
(Tue Mar 24 12:21:21 2009
) command [e:\PSFT\PSV9EMEA\bin\sqr\ORA\BINW\sqrw d:\APPL\universe\UBIPRD\exec\uxpsoft8\uxsynpsoft.sqr SYSADM/[password]@PSV9EMEA -Ie:\psft\psv9emea\sqr\,d:\appl\universe\ubiprd\exec\uxpsoft8\ -Fd:\APPL\universe\UBIPRD\exp\log\ -Ed:\APPL\universe\UBIPRD\exp\log\Psoft_ERPDBEMEA_X_PSF_TEST_0000015.err -Od:\APPL\universe\UBIPRD\exp\log\Psoft_ERPDBEMEA_X_PSF_TEST_0000015.log -debug -ZIFe:\psft\psv9emea\sqr\pssqr.ini -XCB -XMB 7520 d:\APPL\universe\UBIPRD\exp\log\Psoft_ERPDBEMEA_X_PSF_TEST_0000015.inp]

I think it comes with the trace mode activated to yes.

Thanks for your help,

Attached Files

•  IU_WMNT.txt   8.74K   3 downloads

[men]

Hello,

While waiting for colleagues insight, a reply about IU_PUR.

In case IU_PUR does not exist (it may exist if yoy installed a V500 at a certain point and upgraded it to higher releases), just check the uxsetenv file to check the parameters of the continuous purge as described in this topic. Particularly check post 7 which is the first version of the continuous purge and post 6 which describes the lastest evolutions of this purge with lastest release and patches.

Michel

[UxSteF]

men, on February 4 2010, 07:08 PM, said:

Hello,

While waiting for colleagues insight, a reply about IU_PUR.

In case IU_PUR does not exist (it may exist if yoy installed a V500 at a certain point and upgraded it to higher releases), just check the uxsetenv file to check the parameters of the continuous purge as described in this topic. Particularly check post 7 which is the first version of the continuous purge and post 6 which describes the lastest evolutions of this purge with lastest release and patches.

Michel

Hi,

I just verify following your recommandations and that's right, there's a "Uxsetenv_CompanyName.bat" present in the mgr folder which have 7 days retention on the Execution panel.

Thanks for the information !

[glc]

Hello

About the .inp and .out files; they are indeed generated by the Manager for PeopleSoft.

I think you have the trace mode activated on it, that would explain why there are not purged.

Please, check your uxpsoftenv.bat file located on your $U MGR folder.
Check if the trace mode is activated inside it.
If so, you should put it back to "N".

Those files should be deleted after Manager for Psoft uprocs completion.


Do not hesitate to keep us updated about it

cheers,
Guillaume