Hello,
We recently upgraded to CIS 6.2.4.0 on AIX 7.2 TL 1. We have a sqlite database around 430MB and was trying to export the contents to a file shown below, perfomred this with other databases but it seems there is some type of limitation possibly with the version of sqlite we are running? We did open a ticket with IBM which looked at the core dump and said it was on the application side, sqlite. We ended up doing 3 select statements using a unique number to pull files of about 500k of rows to finally clear the table. I’ve reached out to the sqlite.org user group and their initial reply was asking why is such an outdated version of sqlite being used. After doing an install for CIS6.2.4.0 it looks like this is the version that comes with the base install. Has anyone upgraded to a more recent version of sqlite on AIX?
SQLite version 3.7.14.1 2012-10-04 19:37:12
Enter “.help” for instructions
Enter SQL statements terminated with a “;”
sqlite> select count(*) from EpicADT;
1457871
sqlite> .output finalAllHospTable.txt
sqlite> select * from EpicADT ORDER BY acctNum;
Memory fault(coredump)
iscax_testcis02@hci (/cistest/cis6.2/integrator/sqlLiteDbs/JGD)
/>ls -altr
total 1378760
-rw-r–r– 1 hci staff 436788224 Oct 29 15:46 EpicADT_PROD1TBL.db
drwxrwxr-x 20 hci staff 4096 Oct 29 15:48 ..
-rw-rw-r– 1 hci staff 0 Oct 29 15:48 finalAllHospTable.txt
drwxrwxr-x 2 hci staff 256 Oct 29 15:49 .
-rw-rw-r– 1 hci staff 269121503 Oct 29 15:49 core
Table schema
sqlite> .schema
CREATE TABLE EpicADT (msgDT TEXT, msgID TEXT, hosp TEXT, FirstName TEXT, MI TEXT, LastName TEXT, DOB TEXT, Gender TEXT, pt
AIX Power 8 + server 16 cpu’s running
/>ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) unlimited
memory(kbytes) unlimited
coredump(blocks) unlimited
nofiles(descriptors) 20000
threads(per process) unlimited
processes(per user) unlimited