Home » Posts tagged "IQ"

HOWTO: Connect to SAP Sybase IQ Multiplex using JDBC and the SQL Anywhere driver: “Connection error: TCPIP requires a server name”

SAP IQ Data Warehouse

SAP’s documentation, like other vendors, often sucks. In today’s wonderful documentation sucky-ness the examples from SAP to connect to IQ using a JDBC connection string like so: “jdbc:sqlanywhere:UID=***;ENG=MyIQ;PWD=***;links=tcpip(Host=MyIQ;PORT=40000)” This is fine except when you connect to IQ multiplex and you have logical servers set up....

Continue reading »

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 »

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 »

SAP Sybase IQ and ODBC (Linux/UNIX)

SAP IQ Data Warehouse

Connecting to SAP Sybase’s IQ server shouldn’t be scary but the documentation leaves a lot to be desired. Log on to your favorite Linux or Unix box and make sure you source the IQ.sh file wherever you installed the software. Let’s use the following hypothetical...

Continue reading »

Facebook login by WP-FB-AutoConnect