Thanks Alain,
REORG got completed however UNLOAD got failed with the Below error. For both the jobs we are using same user account which has admin privileges on the server.
Connected with agent 'PRD2K12AP14'
Program 'UC4 Job Messenger' version '12.0.1+build.632' terminated normally
C:\Automic\Automation.Platform\Utility\bin>UCYBDBun -B REORG
Permission denied, can't create logfile ..\TEMP\ucybdbun_log_00.txt========================================================
Starting C++ batch mode loader...
User account (user/domain) <AUTOMIC/TVCORP>
Startup parameter <-B REORG >
Application name <UCYBDBun>
Launch from <.\>
LoadLibrary <.\ucybdbun.dll>
LoadLibrary pointer = <00007FFA4E830000>
Application return code = 1
======================
Job Defintion::SET &unloading# = GET_VAR('VARA.DATABASE_MAINTENANCE','UNLOADING'):IF &unloading# = 'Y'UCYBDBun -B REORG:ELSE: PRINT 'Unloading of data records shall not take place.':ENDIF@set retcode=%errorlevel%
@if NOT %ERRORLEVEL% == 0 goto :retcode
Thanks
Shani
Original Message:
Sent: 06-29-2020 04:50 AM
From: Alain Moisy
Subject: DB Maintenance (REORG)
No impact. Act only on ended and deactivated process.
Original Message:
Sent: 06-29-2020 04:45 AM
From: kushwaha
Subject: DB Maintenance (REORG)
Hi Alain/Peter,
My bad here, Thanks for pointing out. I have corrected t and the job is running now.
One more question: what is the effect of these jobs on the AE performance also if I run the Unload now, will it effect any running processes.(as per my understanding it should not have any effect on running or defined objects)
Thanks
Shani
Original Message:
Sent: 06-29-2020 04:23 AM
From: Peter Grundler
Subject: DB Maintenance (REORG)
Hi Shani,
the reorg program is started using the script variable &client# but this variable is not defined. The routine only creates &reorganizing# and &mclient#. The logic looks like &mclient# has to be used.
regards,
Peter
Original Message:
Sent: 06-29-2020 03:00 AM
From: kushwaha
Subject: DB Maintenance (REORG)
Hi All,
Needed some help here. I am trying to set the the DB Maintenance Workflow in our Environment, I tested the jobs in NON Prod and they are working fine. However When I try to execute them in PROD, Archive Job completes successfully however in REORG job I start to get error.
Process Tab: REORG and UNLOAD in VARA.DATABASE_MAINTENANCE are set to Y
:SET &reorganizing# = GET_VAR('VARA.DATABASE_MAINTENANCE','REORGANIZING')
:SET &mclient# = GET_VAR('VARA.DATABASE_MAINTENANCE','CLIENT')
:IF &reorganizing# = 'Y'
UCYBDBre -B -S&client#
:ELSE
: PRINT 'Reorganization shall not take place.'
:ENDIF
@set retcode=%errorlevel%
@if NOT %ERRORLEVEL% == 0 goto :retcode
Output :
C:\Automic\Automation.Platform\Utility\bin>UCYBDBre -B -S & client#
Could not find a client value
========================================================
Starting C++ batch mode loader...
User account (user/domain) <AUTOMIC/TVCORP>
Startup parameter <-B -S >
Application name <UCYBDBre>
Launch from <.\>
LoadLibrary <.\ucydbreorg.dll>
LoadLibrary pointer = <00007FFA4E860000>
Application return code = 1
'client#' is not recognized as an internal or external command,
operable program or batch file.
Someone please suggest if I have made a mistake somewhere.
Thanks
Shani