Hi Experts,
I tried to rerun maxinst using command ./maxinst.sh -sMAXDATA -tMAXDATA -imaxdemo from the IBM technote below:
How to run MAXINST in a MAS environment (ibm.com)
However the console timed out, I tried rerunning the nohup ./maxinst.sh -sMAXDATA -tMAXDATA -imaxdemo > Maxdata.log & command but seems no activity is happening.
When I tried to manually rerun the MAXINST command using the previous command I get the following error below:
;
drop table apiroute
;
commit
;
create table apiroute ( route varchar (50) not null, httpmethod varchar (10) not null, classname varchar (100) not null, app varchar (40), optionname varchar (25), description varchar (200), active integer not null, apirouteid bigint not null PRIMARY KEY , rowstamp bigint not null ) in MAXDATA index in MAXDATA
;
drop table apirouteprop
;
commit
;
create table apirouteprop ( route varchar (50) not null, httpmethod varchar (10) not null, propname varchar (20) not null, propvalue varchar (200) not null, apiroutepropid bigint not null PRIMARY KEY , rowstamp bigint not null ) in MAXDATA index in MAXDATA
;
drop table appdoctype
;
commit
;
create table appdoctype ( app varchar (40) not null, doctype varchar (16) not null, appdoctypeid bigint not null PRIMARY KEY , rowstamp bigint not null ) in MAXDATA index in MAXDATA
;
drop table appfielddefaults
;
commit
;
create table appfielddefaults ( app varchar (40) not null, siteid varchar (8), grpname varchar (30), username varchar (30), defaultvalue varchar (50), objectname varchar (30) not null, attributename varchar (50) not null, appfielddefaultsid bigint not null PRIMARY KEY , rowstamp bigint not null ) in MAXDATA index in MAXDATA
;
drop table applicationauth
;
commit
;
create table applicationauth ( groupname varchar (30) not null, app varchar (40) not null, optionname varchar (25) not null, applicationauthid bigint not null PRIMARY KEY , conditionnum varchar (12), rowstamp bigint not null ) in MAXDATA index in MAXDATA
;
com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=MAXIMO.APPLICATIONAUTH;TABLE, DRIVER=4.32.28
at com.ibm.db2.jcc.am.b7.a(b7.java:810)
at com.ibm.db2.jcc.am.b7.a(b7.java:66)
at com.ibm.db2.jcc.am.b7.a(b7.java:140)
at com.ibm.db2.jcc.am.lc.c(lc.java:2868)
at com.ibm.db2.jcc.am.lc.d(lc.java:2852)
at com.ibm.db2.jcc.am.lc.b(lc.java:2212)
at com.ibm.db2.jcc.t4.ab.k(ab.java:444)
at com.ibm.db2.jcc.t4.ab.c(ab.java:102)
at com.ibm.db2.jcc.t4.p.b(p.java:38)
at com.ibm.db2.jcc.t4.av.h(av.java:124)
at com.ibm.db2.jcc.am.lc.ak(lc.java:2207)
at com.ibm.db2.jcc.am.lc.a(lc.java:3412)
at com.ibm.db2.jcc.am.lc.e(lc.java:1138)
at com.ibm.db2.jcc.am.lc.execute(lc.java:1117)
at psdi.configure.Maxinst.doSql(Maxinst.java:2370)
at psdi.configure.Maxinst.doOneUnlcvtLine(Maxinst.java:645)
at psdi.configure.Maxinst.doUnlcvtSql(Maxinst.java:499)
at psdi.configure.Maxinst.process(Maxinst.java:414)
at psdi.configure.Maxinst.main(Maxinst.java:2847)
DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=MAXIMO.APPLICATIONAUTH;TABLE, DRIVER=4.32.28 Mon Sep 09 13:31:10 GMT 2024
DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=MAXIMO.APPLICATIONAUTH;TABLE, DRIVER=4.32.28 Mon Sep 09 13:31:10 GMT 2024
BMXAA6819I - Maxinst completed with errors. Mon Sep 09 13:31:10 GMT 2024
BMXAA6819I - Maxinst completed with errors. Mon Sep 09 13:31:10 GMT 2024
sh-4.4$