Home / SAP IQ

SAP IQ

Getting Started with SAP IQ

You’ve just successfully installed SAP IQ. What should you do next? Some useful videos can help you through the process. First, you need to create a new database. Learn how to configure your environment and then create a new database in Creating an SAP IQ Database. Once you’ve created your …

Read More »

SAP IQ: Documentation Now Accessible to Search Engines

For the first time in many years you can use popular search engines — such as Google and Bing — to search SAP documentation, including SAP IQ documentation. (Previously, the SAP Help Portal and Sybase InfoCenter contents were inaccessible to search engines.) Try a Google search. For example, search for …

Read More »

SAP IQ Documentation: Where’s the PDF?

Did you know you can download SAP IQ manuals in PDF format? For versions 16.0 SP 11 and 16.1 SP 01, a PDF icon displays on the right side of the user interface. Click the PDF icon to open the manual in PDF format. Navigate to the documentation collection you’re interested …

Read More »

How to Search the SAP IQ Documentation

As of 07 April, 2017, the SAP IQ 16.0 SP 11 documentation collection — and all subsequent documentation releases — are fully searchable! You can search across the entire documentation collection, or you can search inside a single document. This blog post will show you the basics of searching, using SAP IQ …

Read More »

Copying data from one IQ server to another on the same platform

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. Scenario: a new IQ server has been created with DBSpaces different from the original and the size of the tables are manageable (can be handled …

Read More »

Leveraging Load Balancers with SAP IQ

In an SAP IQ Multiplex grid, you have any number of nodes/machines that can handle and process user query requests.  Often, the challenge becomes how to distribute the user connections across these nodes so that the compute power is fully leveraged without creating hot spots, or hot nodes.  Historically, SAP …

Read More »

Basic Note

SAP Agile Data Preparation lets you discover, prepare, and share data how and when you need it – without depending on IT for help. The tool makes it easy for business users and analysts to quickly prepare data sets with a visual, interactive interface that helps eliminate the inefficiencies of …

Read More »

SAP BW: Implementation of NLS with SAP IQ 16.0

Hi Friends, This is my first document release in SCN .I am very much interested in Sharing my thoughts and Knowledge.Recently we have implemented Near Line Storage for One of our Major Client.I would like to share the experience and knowledge during implementation. SAP  IQ SERVER: SAP  IQ is a …

Read More »

How to send an email containing query results using xp_sendmail()

This document is to show you how to send email using xp_sendmail(). This test was conducted on a Windows 7(64bit) The steps to be done are  a little simple as below. CALL xp_startsmtp( ‘test_sender@mytestdomain.com‘, ‘mymailserver.mytestdomain.com’ ); CALL xp_sendmail( recipient=’test_account@mytestdomain.com‘,subject=’This is a test’, query=’sp_iqdbspace’ ); CALL xp_stopsmtp( ); But, there is …

Read More »

Reporting on NLS (Near-Line Storage) Archive

     Near-line Storage (NLS) is used to archive BW data which can still be available for reporting using BEx queries. If you are behind BI Optimization, it is a great way to save BW database space by moving less frequently used data to NLS. The Near line data is stored …

Read More »

[Share] Failed to check out an IQ_Core license on AIX.

An IQ server failed to check out an IQ_CORE license with an error below. The IQ server’s version was SAP IQ 16.0 SP11 and was running on a AIX LPAR system. [Error message] Licensing capacity set to PARTITION licensing. All IQ instances running on xxxxxxx (HOSTID=PARTITION-ID=800008ae74a00014) will share licenses. License …

Read More »

How to get the univarchar data from ASE.

Hi, As you know SAP Sybase IQ does not support the Adaptive Server data types UNIVARCHAR. But You can get the univarchar data from ASE using insert location statement. Here are steps to get the univarchar data. [In ASE]   1> create table univarchar_test(c1 univarchar(100))   2> go   1> …

Read More »

Reasonable IQ memory values

For IQ 16 installations in the HEC/MCD  environment – typically NLS related – we apply the following recommendations in the database configuration file: 19% of RAM for Load Memory (-iqlm) 39% of RAM for Main Cache (-iqmc) 19% of RAM for Temp Cache (-iqtc) In IQ Cockpit or sp_iqstatus you …

Read More »

[Share] iqunload may give an error

IQ Version : IQ 15.4 ESD6 / IQ 16.0 SP10/SP11 As introduced in a recent blog, iqunload has been enhanced by adding new options to generate table schemas as well as table data. In a specific case, the iqunload utility may give an error below. [hpita:/home1/DBA] iqunload -c “uid=DBA;pwd=sql;eng=HPIA16” -tld …

Read More »

Significant News Item regarding BusinessObjects & SAP IQ

For those who may be interested: As of January 2016 all net new purchases (and version upgrades) of the BusinessObjects BI Suite now include 8 Cores of SAP IQ, 8 Cores of SAP Data Integrator and 1 SAP PowerDesigner (Data Architect) Concurrent Session License. These items now become a standard …

Read More »

Restore database ..Rename – parallel creating of dbfiles

I am currently migrating a relatively small IQ 16 database to a new location. However, the pre-allocated size of 4 Main and 4 Temp dbfiles is 1 TB each. Creating those files sequentially one-by-one  in an NFS based environment is taking forever. RESTORE database ‘/sybase/PBW_NLS/data/PBW_NLS.db’ FROM ‘/sybase/PBW_NLS/saparch_1/SAPPBWDB.IQfullbkp ‘ RENAME IQ_SYSTEM_MAIN  …

Read More »

Enhancement of iqunload utility for data unload

In the past, iqunload utility could be executed only with migration mode (-au) or schema unload mode (-n). However, table data unload functionality was added to iqunload utility by CR 773343. ——————————————————————————————————- ESD05 773343 The IQUNLOAD tool has been enhanced to support unload of a current iq database schema and …

Read More »

How to change password on command line

SAP IQ 15 and above allows users to change their password using “NEWPWD”  dbisql connection string parameter 1. Create user    (DBA)> create user myuser identified by sql 2. login to SAP IQ server as myuser $ dbisql -c “uid=myuser;pwd=sql;eng=iqmpx1010c” -nogui (myuser)> quit 3. Change myuser password  using  “NEWPWD” connection …

Read More »

Verify SAP IQ Database Consistency for Disaster Recovery

You have regular backups, and a disaster recovery plan.  But would it execute smoothly if worst came to worst? Here’s one way you might check database consistency on your disaster recovery system. Incremental Backup Flavors Many SAP IQ administrators make incremental backups between full backups. You are probably familiar with …

Read More »

Upgrading SAP IQ: Uninstall the Old Version First

When upgrading SAP IQ on a Windows or Unix platform, be sure to uninstall the existing version before installing the new version. It is not recommended that you either install the new version over top of the existing installation or to a different folder on the same server. Failure to …

Read More »

SAP IQ 16 SP10.10

SAP IQ 16 sp10.10 is available for download for all platforms from support portal. CoverLetter with critical bug fixes have been attached. http://support.sap.com/swdc Support Packages and  Patches – I – SYBASE IQ – SYBASE IQ 16.0 AIX  – 64 bit   IQSERV160010P_10-20011178.TGZ HP-UX on IA64 64bit   IQSERV160010P_10-20011179.TGZ Linux on …

Read More »

‘Cannot use view ‘v1’ because it is invalid.’ error.

I’m going to share with you about an error below happened when querying against a view. It happened on the IQ 16.0 SP10 PL08 and the reproduction scenario is as below. ============================================================== T1. Creation of table & view create table jerry(a int, b int, c int ); insert jerry values(1,1,1);commit; …

Read More »

How to assigns a priority to each query waiting in the -iqgovern queue.

1. Problem Unable to increase the value of IQGOVERN_PROIRITY option for an individual user. >> set option gjang.iqgovern_priority=1 [Error] Could not execute statement. Invalid setting for option ‘IQgovern_priority’ SQLCODE=-201, ODBC 3 State=”42000″ Line 1, column 36 The following options are related to setting the query priority. IQGOVERN_PRIORITY ? Assigns a …

Read More »

How to avoid installation problems with java (jvm).

1. Problem     The setup.bin hangs in the ‘Forking JAVA in launching installer’ stage.          [ How to debug]          – If you add the following to setup.bin, it shows that setup process stopped at the “Forking JAVA step”.            1) ./setup.bin -Dlax.debug.all=true -Dlax.debug.level=3         [LAX …

Read More »