SAP IQ: iqinit error SQLCode: -1000338, SQLState: ‘QDD38’, Severity: 14: Insufficient cache to allocate free list SOLVED

SAP IQ Data Warehouse

When you create a new IQ v16 instance, you need to use the iqinit program for initial creation of the database. iqinit -iqpath '/siq/devices/main001.iq' -iqpgsize 131072 -iqblksize 16384 -p 4096 -iqtmppath '/siq/devices/temp001.iqtmp' -dba DBA,SUPER_PASSWORD -m '/siq/devices/myiq.mir' -o '/siq/log/myiq.iqmsg' -t '/siq/devices/myiq.log' -b -c '/siq/devices/myiq.db' Occasionally you...

Continue reading »

Microsoft OneNote for Pros – Smart Note-Taking Tips

OneNote

Learn how you can use hot keys, insert and use Audio/Video, integrate Excel, and check changes/versions to a doc through the history tab to be more productive in OneNote. Work Smart brings tips/tricks from Microsoft IT that improve digital productivity and help create an all-digital...

Continue reading »

SAP IQ: Uptime

SAP IQ Data Warehouse

At some point you will be asked how long your IQ server has been up. To determine when the IQ server was started issue: SELECT PROPERTY('StartTime') Output: 2015-08-14 18:04:53.918 For the number of days, hours, and minutes we can slice and dice like so: --...

Continue reading »

HOWTO: SAP IQ Drop Device File from DBSpace

SAP IQ Data Warehouse

Sometimes when we build an IQ Data Warehouse, our initial space/growth estimate is off significantly enough to warrant reducing the size of the dbspace(s). The process is quite easy put there are a few steps to perform: Determine how much space is used by the...

Continue reading »

Facebook login by WP-FB-AutoConnect