To resolve the SLSENDER mover due to missing PARAMS and SYSLOGQ tables:
TACL> VOLUME $<VOLUME>.<XYGATEMA Installation Subvolume>
TACL> FUP COPY NEWDEFS
TACL> OBEY NEWDEFS
TACL> INFO DEFINE =XMA_PARAMSTBL
Output should return something such as:
Define Name =XMA_PARAMSTBL
CLASS MAP
FILE \nodename.$DATA.XMADAT.PARAMS
Create params table in XMADAT SUBVOL
TACL> VOLUME $<VOLUME>.<.XMADAT SUBVOLUME>
TACL> SQLCI
>> CREATE TABLE =XMA_PARAMSTBL ( SERVERCLASSTYPE CHAR(15) NO DEFAULT NOT NULL
,SERVERCLASSNAME CHAR(15) NO DEFAULT NOT NULL
,PARAMNAME VARCHAR(50) NO DEFAULT NOT NULL
,PARAMVALUE VARCHAR(256) NO DEFAULT NOT NULL
,PARAMDESC VARCHAR(50) NO DEFAULT NOT NULL
,PRIMARY KEY ( SERVERCLASSTYPE, SERVERCLASSNAME, PARAMNAME )
)
CATALOG =XMA_CAT
ORGANIZATION K
AUDIT;
CREATE TABLE =XMA_SYSLOGQ
( PARTITIONKEY NUMERIC( 4, 0) DEFAULT 1 NOT NULL
,ENTRYGMT TIMESTAMP NO DEFAULT NOT NULL
,PART SMALLINT NO DEFAULT NOT NULL
,ACTIONGMT TIMESTAMP NO DEFAULT NOT NULL
,ALERTEDGMT TIMESTAMP NO DEFAULT NOT NULL
,ACTION CHAR(1) NO DEFAULT NOT NULL
,TCP_PROCESS CHAR(9) NO DEFAULT NOT NULL
,RETRIES SMALLINT NO DEFAULT NOT NULL
,MESSAGE_LEN SMALLINT NO DEFAULT NOT NULL
,TARGET_PORT SMALLINT NO DEFAULT NOT NULL
,TARGET_HOST VARCHAR(64) NO DEFAULT NOT NULL
,PREFIX VARCHAR(79) NO DEFAULT NOT NULL
,MESSAGE VARCHAR(1000) NO DEFAULT NOT NULL
,PRIMARY KEY (PARTITIONKEY, ENTRYGMT, PART)
)
CATALOG =XMA_CAT
ORGANIZATION K
AUDIT;
CREATE INDEX =XMA_SYSLOGQIND ON =XMA_SYSLOGQ
( ACTION, ALERTEDGMT, ENTRYGMT )
CATALOG =XMA_CAT
EXTENT (48,256) MAXEXTENTS 900;
TACL> EXIT
TACL> VOLUME $<VOLUME>.<XYGATEMA Installation Subvolume> TACL> sqlcomp/in slsender,out $s.#compsl/catalog =xma_cat
sqlcomp/in mamgrc,out $s.#compmg/catalog =xma_cat
Output should return something such as
TACL> sqlcomp/in slsender,out $s.#compsl/catalog =xma_cat
****** Old object file has been renamed to \nodename.$VOL.XYGATEMA.ZZND0642******
STOPPED: $X0X9
CPU time: 0:00:00.229
1: Process terminated with warning diagnostics
NOTE: If you get warning messages, this will not normally stop the compile process. Please send the output to XYPRO Support Team.
To restart SLSENDER Mover:
TACL> VOLUME $<VOLUME>.<XYGATEUA Installation Subvolume>
TACL> RUN XMA INSTALL
TACL> XMA_MANAGER
Select 2: MOVERS
Select 18: CONFIGURE SYSLOG SEND SERVER
Select R: RUN
It should return an output such as
Command completed successfully
Starting SysLog Send server...
Command completed successfully
Press Return to continue ...
Select X: Exit the menu
TACL>
If this article did not provide a solution, please open a case with our support team by sending an email message to support@xypro.com.