This content has been marked as final. Show 5 replies
As the error message suggests you need to increase the temporary data partition which is the TempSize parameter in your DSN.
As a starting point set it to 1000 and then monitor it in ttIsql with the dssize command to see if it needs increasing further or can be reduced after some workload has been run.
The "ownership information" table mentioned in the error stores metadata concerning which node of a TT grid that a row (or "instance") in a global AWT cachegroup is stored on. Ownership tables are stored in the Temp section of the TT memory segment, hence the need to size the Temp section much larger than you might have anticipated. If you login as the instance administrator to [my_ttdb], and run "alltables", check for a table owned by schema "GRID". This will be the ownership table for your cachegroup.
thanks, I will try a bigger value for TempSize.
Does PermSize mean the max size of shard memory?
If loading data in oracle is bigger than PermSize, will issuing a load statement on ttisql fail too?
Please see a description of PermSize and TempSize here1 person found this helpful
You need to configure a PermSize big enough to accommodate all the data you want to store in TimesTen.
Please also see ttSize http://docs.oracle.com/cd/E21901_01/doc/timesten.1122/e21643/util.htm#autoId29 for help on sizing the PermSize.
After resizing PermSize and TempSize, load statement is executed successfully.
Thanks all, this is a really great community.