Topics

46

Report Indexing / Generic Indexing : Batch Vs Single

« on: June 09, 2021, 11:44:21 AM »

I am noticing that our one Line of Business will send tens of thousands of files to CMOD. All with one-two documents, that uses the generic indexer (User Defined PDF / HTML)

Obviously I've followed best practices with AFP files and the like, send down a large batch, let cmod compress'em.

I am actually trying to convince the business to send down PDF's with PPD's, not sure if they can change the HTML files we receive though.

However, until then..Trying to build a case.

Is there a very large benefit in load times when doing a generic indexed file- To do lets say, 1000 docs in a file, compared to 1-5? I am going to assume so, because arsload is only called once, one set of inserts, one logon/logoff, etc.

thanks in advance

47

MP Server / Upgrade from Redhat 6-7, CMOD 9.5-10.5, Latency Issues

« on: June 08, 2021, 05:00:42 AM »

Little background of our environment, 1Lib Server, 1 Obj Serv, RHEL + DB2, DB2 storage is on SAN Veritas Cluster, CMOD Cache is also on Veritas Cluster

We just upgraded from Redhat 6.8 to Redhat 7.9 Maipo. After a few days we noticed slow response times from our API's calling via ODWEK (Weblogic). These requests would timeout after around 20 seconds, causing impact to our customers. We also see instances where loading is slow, example- 12.8 Seconds to load a file with 11 Docs..500kb size.. using generic indexer (user defined html file).

We opened up a case with IBM, and the first suggestion was to upgrade CMOD to 10.5, so we did that, the CMOD upgrade went perfectly fine - and the issue persisted. We checked all of our DB2 (V11.1fp4) logs, and we don't see anything. CMOD says they cant see anything wrong, and I agree with them. the only thing they are seeing is a pause/delay in the system log..There was a 40-50 second delay where there was absolutely no activity, whereas for the whole day there is usually stuff going on. After that pause, there's some 6second long queries in the 226 records.

We also pulled in DB2 Support, and we are giving them updates/db2mon/db2logs - but i dont feel like we are getting anywhere.

Veritas is looking at our system, along with Redhat support.

We've engaged several of our DBA's, Storage Engineers, and System Admins to address the issues.

One of our SA's suggested rolling back the RHEL kernel to 7.8, due to some major features added in 7.9. We did that overnight, and sure enough when I logged on this morning, no bueno.

The biggest issue, is that the problem is intermittent. Our next step is to run on one library server instead of lib/obj to rule out any kind of network latency or anything like that. I also think it might be a shot moving the DB2 volumes off veritas to local disk, or something.

I am open to any possible feedback, if anyone has encountered issues going from RHEL6-7.

48

MP Server / db2 cleanup against system log

« on: May 27, 2021, 08:08:00 AM »

Just wondering if its a common practice for folks to run arsmaint against the system log.

Ours is fairly large I guess, 1B+ rows. I am not sure in the scheme of things if that is "large" but it's taking up alot of space.

It's difficult for our client to get space which is.. strange.

We're considering doing a cleanup against the system log, unused storing, 84/85/83/82/81..226/65/66 (Need to check with compliance), arsmaint, etc.

Wondering if anyone does this? Is it common? we'd probably make a backup of all the tables, and compress it, then store it in TSM or our sharepoint.

Thanks gang

49

MP Server / arslog vs system trace for troubleshooting.

« on: May 24, 2021, 11:27:05 AM »

We encountered a production issue on Friday where ARSSOCKD would randomly crash, on two occasions.

We turned on trace but i have concerns with using that in a production system with heavy loads/retrievals/queries, and the issue possibly not happening again. I noticed in our QA system that we are using the arslog user exit. I have never personally used

I tested bringing down DB2, and i saw all those errors in the syslog.log.

ARS0013E DB Error: [IBM][CLI Driver] CLI0106E  Connection is closed. SQLSTATE=08003 -- SQLSTATE=08003, SQLCODE=-99999, File=arsseg.c, Line=6269 does n
ot exist

ARS0013E DB Error: [IBM][CLI Driver] SQL1224N  The database manager is not able to accept new requests, has terminated all requests in progress, or ha
s terminated the specified request because of an error or a forced interrupt.  SQLSTATE=55032  -- SQLSTATE=40003, SQLCODE=-1224, File=arsid.c, Line=30
78 does not exist

Are there any performance implications as to using the arslog user exit in a production system, primarily on the performance side of things? How would this be compared to using TRACE with ALL=3?

50

MP Server / Unable to start CMOD V10.5 after upgrade from V9.5

« on: April 27, 2021, 01:45:37 PM »

We just upgraded from CMOD V9.5 to V10.5.0.2 Our environment is redhat, with db2 v11.1.4.5, redhat linux

I ran all the upgrade steps-

arsdb -I archive -evf, select yes
arsdb -I archive -uv
arsdb -I archive -rfv
arsdb -I archive -rfv

I updated all the configuration files. Verified everything looks good, and we are seeing this error. I attempt to start arssockd, and it gets to the "initializing phase" and then dies out.

From the trace file-

Code: [Select]

55663:47042139134656 04/27/2021 15:34:21:755929 ERROR arssys.c(3949)ArcDB_SystemGetConfig:Unable to execute sql db hstmt=65538 db sql str=SELECT keystore_type, keystore_location, keystore_mkl, keystore_mkl_dt, data_ekey FROM archive.ARSSYS FETCH FIRST 1 ROW ONLY OPTIMIZE FOR 1 ROW FOR READ ONLY db sql rc=-1,SQL_ERROR
55663:47042139134656 04/27/2021 15:34:21:861056 ERROR arssys.c(3950)ArcDB_SystemGetConfig:Server message msg timestamp=2021-04-27 15:34:21.757220 msg userid=ARSSOCKD msg severity=2 msg num=13 msg text=ARS0013E DB Error: [IBM][CLI Driver][DB2/LINUXX8664] SQL0206N  "KEYSTORE_TYPE" is not valid in the context where it is used.  SQLSTATE=42703  -- SQLSTATE=42S22, SQLCODE=-206, File=arssys.c, Line=3950 msg appl=N msg logid=0
55663:47042139134656 04/27/2021 15:34:21:861061 ERROR arssys.c(3950)ArcDB_SystemGetConfig:ARSLOG message msg num=13
55663:47042139134656 04/27/2021 15:34:21:861318 ERROR arssys.c(3950)ArcDB_SystemGetConfig:CONSOLE message msg num=13
55663:47042139134656 04/27/2021 15:34:21:861586 ERROR arssrvr.c(3168)ArcSERVP_GetSystemInfo:TTY message msg num=151 msg text=ARS0151E Unable to initialize server database system parameters.  Contact your system administrator.
55663:47042139134656 04/27/2021 15:34:21:861631 ERROR arssrvr.c(3168)ArcSERVP_GetSystemInfo:CONSOLE message msg num=151 msg timestamp=2021-04-27 15:34:21.861591 msg userid=ARSMSG msg severity=2 msg text=ARS0151E Unable to initialize server database system parameters.  Contact your system administrator. msg appl=N msg logid=0
55663:47042139134656 04/27/2021 15:34:21:861647 ERROR arssrvr.c(3168)ArcSERVP_GetSystemInfo:ARSLOG message msg num=151
Found an earlier post, mentions this-

Code: [Select]

EXPORT
DROP
CREATE
IMPORT
 
Run "arsdb <-I instance_name> -vx ARSSYS"
Run "arsdb <-I instance_name> -vd ARSSYS"
Run "arsdb <-I instance_name> -vc ARSSYS"
Run "arsdb <-I instance_name> -vi ARSSYS"

Before I do that, just wondering if anyone on here has seen this error message as well.

51

MP Server / Issue configuring new environment

« on: March 19, 2021, 07:12:18 AM »

I'm working on a POC and for some reason I cant get the install to work. I've done plenty of these so I am scratching my head. I have a feeling its simple.

1) Instance is created as "db2inst1"-

Code: [Select]

[db2inst1@ondemand ~]$ db2ilist
db2inst1
[db2inst1@ondemand ~]$ groups
db2iadm1
[db2inst1@ondemand ~]$
2) "archive" user is part of db2iadm1, attempting to run arsdb -gcv -I archive

Code: [Select]

[archive@ondemand config]$ groups
db2iadm1
[archive@ondemand config]$ arsdb -I archive -gcv
ARS4014E Unable to load >DB2<

3) ars.cfg / ars.ini are both basically untouched

Code: [Select]

[archive@ondemand config]$ more ars.ini
[@SRV@_ARCHIVE]
HOST=
PROTOCOL=2
PORT=0
SRVR_INSTANCE=ARCHIVE
SRVR_INSTANCE_OWNER=archive
SRVR_OD_CFG=/opt/ibm/ondemand/V10.1/config/ars.cfg
SRVR_DB_CFG=/opt/ibm/ondemand/V10.1/config/ars.dbfs
SRVR_SM_CFG=/opt/ibm/ondemand/V10.1/config/ars.cache

Code: [Select]

ARS_ORIGINAL_CODEPAGE=0
DB2INSTANCE=db2inst1
ARS_DB2_DATABASE_PATH=/arsdb
ARS_DB2_PRIMARY_LOGPATH=/arsdb_primarylog
ARS_DB2_ARCHIVE_LOGPATH=/arsdb_archivelog
ARS_DB2_LOGFILE_SIZE=1000
ARS_DB2_LOG_NUMBER=40
I verified that all the directories are created, owned by archive:db2iadm1, set to 775

I think it's something with the archive profile, permissions or something like that. Usually I use all the default settings - archive instance/archive db.. But I want the default db2instance name of db2inst1 because I will be installing other products on here and I would like to keep things organized anyone have suggestions? I unfortunately don't have a dba to help me.

52

MP Server / Arsdoc get — best optimized way to extract and reload

« on: March 03, 2021, 09:21:30 PM »

So I am working on a migration and I’m just looking at some possible ways to extract and reload my data.

My thought - arsdoc get with -L, read from parameter file with a listing of load ID’s. Do this on an app group by app group basis. We only have like 10, but a good amount of data.

We have a process, a weird one- that extracts from a “short term” application group and loads into a “long term” application group. This was handled by a third party years ago, and since I joined I redid it with a few basic shell scripts. My script generates a list of dates of the month prior, and loops through that + an app group name, and does all the magic. This process is very good. I can’t wrap my head around why they are going from one app group to another. I think it’s for performance at the db level or something

I figure there’s other ways, where I can extract a month of data per file, etc. so I guess my three options I’m trying to weigh

1) retrieve an entire load, reload with arsload
2) retrieve an entire day, reload with arsload
3) retrieve an entire month, reload with arsload.

I’m leaning towards one. I also think that would be easier to recover if there’s some kind of issue.

What’s everyone’s thoughts.

53

MP Server / determine oldest doc in an app group?

« on: February 24, 2021, 05:24:30 PM »

I have about 2k app groups, need to figure out the oldest record per application group.

I'm looking through the tables -> arsag caught my eye, more specifically 'last_doc_dt'

I ran a simple query, and it's coming back blank.

Code: [Select]

LAST_DOC_DT
--------------------------
-

  1 record(s) selected.
Is there anything on lets say, arsseg I can also try? I was also thinking I could use arsseg table.

Code: [Select]

START_DT TIMESTAMP The minimum (oldest) date of documents stored in this folder, in database-native timestamp format.

54

MP Server / Any easy/fancy ways to gather all loads in one year time frame?

« on: February 23, 2021, 05:20:23 PM »

Business folks are asking for a count of all documents loaded in 2020 for a specific folder. Usually not a big deal, only 6 AG's in that folder..

How I've done it in the past is use the system load / system log folder, and put it into excel..and some simple parsing. But these are large application groups, some have 100k+ loads per month. I've learned obviously that the CMOD client doesn't like copying out more than 30-40k at a time.

My Idea? -- I'm thinking possibly also of just hitting up the SA* tables, of which we have two of. Anyone have any more ingenious ways of doing this?

55

MP Server / Issue with arsdoc query

« on: February 12, 2021, 11:34:14 AM »

CMOD 9.5, DB2 10.1 - Scratching my head on this one, I've done this before but its been a while. I want to just generate a list of 66 messages for a certain time frame. I think this is what i used last time.

arsdoc query -u admin -p stash.file -h archive -f 'System Log' -i "WHERE TIME_STAMP_DT > '2021-02-12-01.00.00.352804' and TIME_STAMP_DT < '2021-02-12-2.43.45.352804' and MSG_NUM='66'"

I want to get all 66 messages, between 2021-02-12-01.00.00.352804 and 2021-02-12-2.43.45.352804

When I run above arsdoc query, I get this.. Notice the dates look funky... Anyone have a thought?

02/11/21 21:30:34,ADMIN,4,66,Application Group Document Get: Name(APPLICATION_AG_S) Agid(5150) ApplName(APPLICATION_APP_S) Aid(5151) NodeName(-CACHE-) Nid(3) Server(server) Time(0.003) ObjName(38657GAAA) Off(0) Len(40646) CompOff(0) CompLen(34621) Size(40646) Seg(1) Total Segs(1) Flds(),A,1271258566,
02/11/21 21:30:31,ADMIN,4,66,Application Group Document Get: Name(APPLICATION_AG_S) Agid(5150) ApplName(APPLICATION_APP_S) Aid(5151) NodeName(-CACHE-) Nid(3) Server(server) Time(0.009) ObjName(42537GAAA) Off(44384) Len(89182) CompOff(0) CompLen(57683) Size(89182) Seg(1) Total Segs(1) Flds(),A,1271258560,
02/11/21 21:30:30,ADMIN,4,66,Application Group Document Get: Name(APPLICATION_AG_S) Agid(5150) ApplName(APPLICATION_APP_S) Aid(5151) NodeName(-CACHE-) Nid(3) Server(server) Time(0.002) ObjName(39760GAAA) Off(0) Len(43120) CompOff(0) CompLen(9725) Size(43120) Seg(1) Total Segs(1) Flds(),A,1271258562,
02/11/21 21:30:29,ADMIN,4,66,Application Group Document Get: Name(APPLICATION_AG_S) Agid(5150) ApplName(APPLICATION_APP_S) Aid(5151) NodeName(-CACHE-) Nid(3) Server(server) Time(0.003) ObjName(39813GAAA) Off(0) Len(49624) CompOff(0) CompLen(11097) Size(49624) Seg(1) Total Segs(1) Flds(),A,1271342777,
02/11/21 21:00:21,ADMIN,4,66,Application Group Document Get: Name(APPLICATION_AG_S) Agid(5150) ApplName(APPLICATION_APP_S) Aid(5151) NodeName(-CACHE-) Nid(3) Server(server) Time(0.003) ObjName(38657GAAA) Off(0) Len(40646) CompOff(0) CompLen(34621) Size(40646) Seg(1) Total Segs(1) Flds(),A,1271258566,
02/11/21 21:00:19,ADMIN,4,66,Application Group Document Get: Name(APPLICATION_AG_S) Agid(5150) ApplName(APPLICATION_APP_S) Aid(5151) NodeName(-CACHE-) Nid(3) Server(server) Time(0.010) ObjName(42537GAAA) Off(44384) Len(89182) CompOff(0) CompLen(57683) Size(89182) Seg(1) Total Segs(1) Flds(),A,1271258560,
02/11/21 21:00:17,ADMIN,4,66,Application Group Document Get: Name(APPLICATION_AG_S) Agid(5150) ApplName(APPLICATION_APP_S) Aid(5151) NodeName(-CACHE-) Nid(3) Server(server) Time(0.003) ObjName(39760GAAA) Off(0) Len(43120) CompOff(0) CompLen(9725) Size(43120) Seg(1) Total Segs(1) Flds(),A,1271258562,
02/11/21 21:00:16,ADMIN,4,66,Application Group Document Get: Name(APPLICATION_AG_S) Agid(5150) ApplName(APPLICATION_APP_S) Aid(5151) NodeName(-CACHE-) Nid(3) Server(server) Time(0.004) ObjName(39813GAAA) Off(0) Len(49624) CompOff(0) CompLen(11097) Size(49624) Seg(1) Total Segs(1) Flds(),A,1271342777,
02/11/21 20:30:19,ADMIN,4,66,Application Group Document Get: Name(APPLICATION_AG_S) Agid(5150) ApplName(APPLICATION_APP_S) Aid(5151) NodeName(-CACHE-) Nid(3) Server(server) Time(0.003) ObjName(38657GAAA) Off(0) Len(40646) CompOff(0) CompLen(34621) Size(40646) Seg(1) Total Segs(1) Flds(),A,1271258566,
02/11/21 20:30:17,ADMIN,4,66,Application Group Document Get: Name(APPLICATION_AG_S) Agid(5150) ApplName(APPLICATION_APP_S) Aid(5151) NodeName(-CACHE-) Nid(3) Server(server) Time(0.008) ObjName(42537GAAA) Off(44384) Len(89182) CompOff(0) CompLen(57683) Size(89182) Seg(1) Total Segs(1) Flds(),A,1271258560,
02/11/21 20:30:15,ADMIN,4,66,Application Group Document Get: Name(APPLICATION_AG_S) Agid(5150) ApplName(APPLICATION_APP_S) Aid(5151) NodeName(-CACHE-) Nid(3) Server(server) Time(0.003) ObjName(39760GAAA) Off(0) Len(43120) CompOff(0) CompLen(9725) Size(43120) Seg(1) Total Segs(1) Flds(),A,1271258562,
02/11/21 20:30:14,ADMIN,4,66,Application Group Document Get: Name(APPLICATION_AG_S) Agid(5150) ApplName(APPLICATION_APP_S) Aid(5151) NodeName(-CACHE-) Nid(3) Server(server) Time(0.004) ObjName(39813GAAA) Off(0) Len(49624) CompOff(0) CompLen(11097) Size(49624) Seg(1) Total Segs(1) Flds(),A,1271342777,
02/11/21 20:00:32,ADMIN,4,66,Application Group Document Get: Name(APPLICATION_AG_S) Agid(5150) ApplName(APPLICATION_APP_S) Aid(5151) NodeName(-CACHE-) Nid(3) Server(server) Time(0.003) ObjName(38657GAAA) Off(0) Len(40646) CompOff(0) CompLen(34621) Size(40646) Seg(1) Total Segs(1) Flds(),A,1271258566,
02/11/21 20:00:30,ADMIN,4,66,Application Group Document Get: Name(APPLICATION_AG_S) Agid(5150) ApplName(APPLICATION_APP_S) Aid(5151) NodeName(-CACHE-) Nid(3) Server(server) Time(0.006) ObjName(42537GAAA) Off(44384) Len(89182) CompOff(0) CompLen(57683) Size(89182) Seg(1) Total Segs(1) Flds(),A,1271258560,
02/11/21 20:00:28,ADMIN,4,66,Application Group Document Get: Name(APPLICATION_AG_S) Agid(5150) ApplName(APPLICATION_APP_S) Aid(5151) NodeName(-CACHE-) Nid(3) Server(server) Time(0.003) ObjName(39760GAAA) Off(0) Len(43120) CompOff(0) CompLen(9725) Size(43120) Seg(1) Total Segs(1) Flds(),A,1271258562,
02/11/21 20:00:26,ADMIN,4,66,Application Group Document Get: Name(APPLICATION_AG_S) Agid(5150) ApplName(APPLICATION_APP_S) Aid(5151) NodeName(-CACHE-) Nid(3) Server(server) Time(0.004) ObjName(39813GAAA) Off(0) Len(49624) CompOff(0) CompLen(11097) Size(49624) Seg(1) Total Segs(1) Flds(),A,1271342777,

56

MP Server / Multiple oracle instances configured on the same box

« on: February 10, 2021, 10:45:49 AM »

We'd like to create a POC where we load to an oracle remote server to measure performance.

Wondering if it's possible to point an existing CMOD/oracle system that is working PERFECTLY to this remote instance. Basically, two CMOD instances, one box.

Assuming we'd just have to modify the ars.ini file to point to a seperate set of ars.** files, create the database with arsdb commands, and fire it up?

57

MP Server / Unable to load to oracle tablespaces

« on: February 04, 2021, 06:33:01 PM »

Hi all,

Fresh oracle DB running 19c (i think..) and CMOD 10.5.

Trying to load using tablespaces,

2021-01-29 02:11:00.050814: ARS1107E An error occurred.  Contact your system administrator and/or consult the System Log.  File=arsload.c, Line=6736

2021-01-29 02:11:00.050851: ARS1158E Failed while attempting to load the database

2021-01-29 02:11:00.311342: ARS1146I Loaded 0 rows into the database

2021-01-29 02:11:00.311378: ARS4311E Loading failed

2021-01-29 02:11:00.311398: ARS4320I Unloading started

Within the system log -

Unable to find SMS tablespace filesystems.  Either the defined SMS filesystems are full or there are no SMS filesystems defined.


these are defined within ars.dbfs-


#‌ Filesystem                        Tablespace Type (SMS)

#‌ --------------------------------------------------------------

‌/u02/oracle/oradata/fs02/archive     SMS

that specified directory exists

/u02/oracle/oradata/fs02/archive: directory

We can manually create a tablespace within above filesystem outside of CMOD, but it wont work for us when we load.

Anyone have suggestions?

58

MP Server / Tuning - Migration to Oracle

« on: January 08, 2021, 10:32:01 AM »

We are currently using CMOD 9.5/DB2 11. Our new system we just stood up is CMOD 10.5/Oracle 19C.


1) We are curious about tuning the database, one of the key things we are looking for is SGA size for the database. Are there any other tuning considerations we need to take into account?

2) We are also looking for information regarding - db reorg/runstats. I believe currently we do all of this through arsdb/arsmaint commands. Is that supported with oracle? Is there a specific way to do it.

59

MP Server / arsdb -rtv fails when creating db (10.5 + oracle)

« on: December 30, 2020, 08:38:22 AM »

We are trying to configure a CMOD 10.5 instance using oracle. We are getting -

[archive@server bin]$ ./arsdb -I u7edp1d1 -rtv
ARS4013E Unable to determine the database engine
[archive@server bin]$

We have tried all troubleshooting methods within the cmod.wiki/documentation with no luck.

CMOD Configs:

archive@server bin]$ more ../config/ars.cfg | grep ORA
# 5622-662 (C) COPYRIGHT IBM CORPORATION 2020
ARS_DB_ENGINE=ORACLE
# ORACLE Parameters (Library Server Only) #
#ARS_ORACLE_HOME=/home/oracle
ARS_ORACLE_HOME=/u01/app/oracle/product/19.7.0
ARS_STORAGE_MANAGER=NO_TSM
[archive@server bin]$

[archive@server bin]$ more ../config/ars.ini
[@SRV@_ARCHIVE]
HOST=server.hostname
PROTOCOL=2
PORT=0
SRVR_INSTANCE=database
SRVR_INSTANCE_OWNER=archive
SRVR_OD_CFG=/opt/ibm/ondemand/V10.5/config/ars.cfg
SRVR_DB_CFG=/opt/ibm/ondemand/V10.5/config/ars.dbfs
SRVR_SM_CFG=/opt/ibm/ondemand/V10.5/config/ars.cache

Environment Variables-

# User specific environment and startup programs
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/19.7.0
DATABASE=u7edp1d1

PATH=$PATH:$HOME/.local/bin:$HOME/bin:$ORACLE_HOME/bin

export PATH
export ORACLE_BASE
export DATABASE

connection strings-

archive@server ~]$ sqlplus archive/welcome123@u7edp1d1

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Dec 29 18:53:36 2020
Version 19.7.0.0.0

Copyright (c) 1982, 2020, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.7.0.0.0

ARCHIVE@server:SQL>

60

MP Server / Escape character in arsdoc query command?

« on: December 22, 2020, 02:14:28 PM »

I'm trying to create a small script that will capture messages from the system log, for lets say the past hour. Looks like some kind of escape characters are being added to the front of my dates in the arsdoc statement..anyone have an idea?

---Output---
archive@server:/home/ondemand/scripts/errorMon> ./test.bash
+ hourAgo
+ now
+ echo 2020-12-22 14:52:29.264607 'Is an hour ago..'
2020-12-22 14:52:29.264607 Is an hour ago..
+ echo 2020-12-22 15:52:29.266762 'Is now..'
2020-12-22 15:52:29.266762 Is now..
+ arsdoc query -h archive -u admin -f 'System Log' -i $'WHERE time_stamp >= \'2020-12-22 14:52:29.264607\' and time_stamp < \'2020-12-22 15:52:29.266762\''

2020-12-22 15:52:29.350117: ARS1609W Specifying passwords on the command line is in-secure due to the text being visible. See the Installation and Configuration Guide for your platform for information about the arsstash command or using Unified Login.

2020-12-22 15:52:30.201722: ARS6007E The server failed during a search operation.  View the System Log for additional messages.

From the system log - DB Error: [IBM][CLI Driver][DB2/LINUXX8664] SQL0420N  Invalid character found in a character string argument of the function "DECFLOAT".  SQLSTATE=22018  -- SQLSTATE=22018, SQLCODE=-420, File=arsdoc.c, Line=3088

---sample script:---

set -x
function hourAgo {
HOURAGO=$(date "+%Y-%m-%d %H:%M:%S.%6N" -d "1 hour ago")
}

function now {
NOW=$(date "+%Y-%m-%d %H:%M:%S.%6N")
}

hourAgo
now

echo $HOURAGO "Is an hour ago.."
echo $NOW "Is now.."

arsdoc query -h archive -u admin -p ondemand -f "System Log" -i "WHERE time_stamp >= '${HOURAGO}' and time_stamp < '${NOW}'"