DB Maintenance (REORG)

[shani kushwaha]

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 

[Tim Quakulinsky]

Hi Shani,

if you haven't solved the problem yourself: I noticed that the variables have different names (&mclient# vs. &client#):

:SET &mclient# = GET_VAR('VARA.DATABASE_MAINTENANCE','CLIENT')

:IF &reorganizing# = 'Y'
UCYBDBre -B -S&client#​

Good luck
Tim

------------------------------
Automation Evangelist
Fiducia & GAD IT AG
---
Mitglied des deutschsprachigen Automic-Anwendervereins FOKUS e.V.
Member of the German speaking Automic user association FOKUS e.V.
------------------------------