Database Software

Hi all,

I'm loading tables from Oracle Database 11G(Source - Linux Machine - A), using ODI(Windows Machine - B) into TimesTen on Exalytics(Linux Machine - C).


We were loading a huge fact table of row count "176,041,880" (whose approx. size is 115GB on Oracle Database) into TimesTen and the session ended with following error in ODI:

---------------------------ODI Error----------------------------------------------

ODI-1217: Session INF_W_GL_OTHER_F (153003) fails with return code 778.
ODI-1226: Step INF_W_GL_OTHER_F fails after 1 attempt(s).
ODI-1240: Flow INF_W_GL_OTHER_F fails while performing a Loading operation. This flow loads target table W_GL_OTHER_F.
ODI-1228: Task SrcSet0 (Loading) fails on the target TIMESTEN connection tt_xyz.
Caused By: java.sql.BatchUpdateException: Batch command 189 failed: [TimesTen][TimesTen 11.2.2.2.0 ODBC Driver][TimesTen]TT0778: Log write failed because filesystem is full -- file "logmgr.c", lineno 6907, procedure "sbLogRecInsert"


--------------------------ttisql Error---------------------------------------------

At this moment when I checked the disk space on Exalytics(where our TimesTen is installed), it showed available space as "0".
I cleared some space on the disk, about 50GB+ then tried to connect the respective DSN, which triggered following Error in ttisql:

Command> connect "dsn=tt_xyz";
*836: Cannot create data store shared-memory segment, error 22*
*703: Subdaemon connect to data store failed with error TT836*
The command failed.
Command>

Command Run Time: Mon Jan 7, 22:01:20


--------------------------tterrors.log---------------------------------------------

Command Run Time: Mon Jan 7, 22:01:20

Error noted for same TimesStamp in tterrors.log:

22:01:23.47 Err : : 21748: TT14000: TimesTen daemon internal error: Error 22 creating shared segment, KEY 0x43100ed6
22:01:23.47 Err : : 21748: -- OS reports invalid shared segment size
22:01:23.47 Err : : 21748: -- Confirm that SHMMAX kernel parameter is set > datastore size
22:01:23.47 Err : : 14405: subd: Error identified in [sub.c: line 2375]
22:01:23.47 Err : : 14405: subd: (Error 836): TT0836: Cannot create data store shared-memory segment, error 22 -- file "db.c", lineno 9683, procedure "sbDbConnect"
22:01:23.47 Err : : 14405: -- file "db.c", lineno 9683, procedure "sbDbConnect"
22:01:23.47 Warn: : 14405: subd: connect trouble, rc 1, reason 836
22:01:23.47 Err : : 14405: Err 836: TT0836: Cannot create data store shared-memory segment, error 22 -- file "db.c", lineno 9683, procedure "sbDbConnect"
22:01:23.47 Err : : 21748: TT14000: TimesTen daemon internal error: Could not send 'manage' request to subdaemon rc 400 err1 703 err2 836
22:01:24.47 Warn: : 21748: 14405 ------------------: subdaemon process exited


-----------------------------sysctl.conf------------------------------------------

# Controls the maximum shared segment size, in bytes
############### Original
#kernel.shmmax = 68719476736
kernel.shmmax = 1099511627799

# Controls the maximum number of shared memory segments, in pages
kernel.shmall = 4294967296
kernel.shmmni = 4096
kernel.sem = 2048 64000 256 64

net.ipv4.tcp_rmem = 16777216 16777216 16777216
net.ipv4.tcp_wmem = 16777216 16777216 16777216
net.ipv4.tcp_mem = 16777216 16777216 16777216
net.core.optmem_max = 16777216
net.core.rmem_max=16777216
net.core.wmem_max=16777216
net.core.rmem_default=16777216
net.core.wmem_default=16777216
net.ipv4.ip_local_port_range = 9000 65500
# Changed from 10000 to 55000 by ME on Aug 6 2012
# Changed by ME to 150000 on Aug 24, 2012
vm.nr_hugepages = 410000
#
fs.file-max=262144
#Added by ME on Aug 6 2012
vm.hugetlb_shm_group = 500



---------------------------SYS.ODBC.INI----------------------------------------

[tt_xyz]
Driver=/u01/app/EXALYTICS_MWHOME/../TimesTen/tt1122/lib/libtten.so
DataStore=/u01/app/EXALYTICS_MWHOME/../aggregate_store/tt_xyz
LogDir=/u01/app/EXALYTICS_MWHOME/../aggregate_store/logs
DatabaseCharacterSet=AL32UTF8
ConnectionCharacterSet=AL32UTF8
LogFileSize=1024
LogBufMB=10240
LogBufParallelism=20
Preallocate=0
PermSize=600000
TempSize=200000
MemoryLock=4
CkptFrequency=30
CkptLogVolume=0
CkptRate=20
PrivateCommands=1
RangeIndexType=1
Connections=1024
RecoveryThreads=40

I'm unable to connect to this DSN anymore.
Does increasing LogFileSize will help? or is the problem related with shmmax and shmni in sysctl.conf?
Please help me with this issue, as we are in the middle of a Demo.

Thanks.