We are in ASE 15.0.3 and if I run an "update index statistics" and if the compatibility is set to 'full' server-wide, what impact will this have on the optimizer?
I'm re-posting this for future reference. It's not my original posting but from More details is available at:
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.iq_12.6.iqref/html/iqref/X315746.htm. Please refer to this for details....
I was asked a similar question on an older version of IQ and replied:".. IQ, being a sort of DSS (not OLTP), does not have a log shipment capability similar to ASE (for SAP) or Oracle (as mentioned) nor SQL server (Microsoft) or DB2 (IBM flavours), s...
have a look at your interfaces file (in Unix) or sql.ini file in Windows and check the server instance name/port number and use that combination for your -N parameter for ddlgen
I agree with you, Bret, that going to ASE 15.7 or 16.x is the way to go but in reality (short-term of immediate option), application changes and its repercussion is an expensive exercise, not to mention the downtime to clients, if not planned properl...
Hi Eisen,
the restore will re-size the target IQ stores and you will notice the rest of the space (if its bigger) will not be usable by IQ and then moving it to the other IQ dbspaces (and drop them) might do the trick.
Try it and let us know how yo...
if its a simple copy of an IQ database to another, that will suffice. But if you vary the size of the IQstore, or the number if IQ devices, then that is not possible -- but do correct me if I'm wrong (pre IQ ver 16)
