Hello and thanks for joining me to learn
about creating an SAP IQ database
using SQL. This video provides the basics
you'll need to create your own database.
IQ runs on Windows and UNIX platforms.
The process to create a database is
basically the same for all. I'll use
Windows for this demonstration and will
point out the UNIX differences where
necessary. You can store the database on
the IQ server or on another machine.
You've stored on another machine the
location must be available to the IQ
server. On Windows you'd map a drive from
the IQ server to the drive on the other
machine. But on UNIX you'd create a share
from a folder on the other machine to
the IQ server. If the database is on the
IQ server the folder with the data files
should be a peer of the IQ installation
folder. Not a child.
A typical IQ upgrade includes a complete
uninstall and reinstall of the IQ
software. Which could accidentally delete
the data folder containing your data.
Finally, if you plan to have multiple
databases running on the same machine,
save each to its own subfolder in the
main data folder. Now that we have
covered the background information
you're ready to create your database. You
can do this with either the IQ cockpit
admin tool or a create database SQL
statement. I'm going to use the SQL
statement option for this demo. The first
step is to start the IQ utility database.
The utility database is a phantom
database that lets you perform a limited
set of tasks on an IQ server. It has a
reserved name, utility underscore DB, and
cannot contain data. At a command prompt
type start underscore IQ then minus su and a
username and password, separated by a
comma. The password must be at least 6
characters long and contain upper and
lowercase letters and numbers. Finally
type minus N and the utility database name.
If the database started successfully on
Windows you see the IQ server icon on
the taskbar. If you hover over it the
database name appears. On UNIX a message
appears at the end of the start process
indicating success.
Once you have utility underscore DB,
running in a command window type DB I
SQL. In the connection window type the
username and password of the utility
database. If needed
set the action to connect to a running
database on this computer. Enter utility
underscore DB in the database name field
and click connect.
DB I SQL connects to the utility
database. The statement that creates your
database uses several optional
parameters to define the databases
features. Most parameters can't be
changed after creation. Familiarize
yourself with the default values to make
sure they meet your system's
requirements before creating your
production database. The default value
for each parameter is listed in the
create database statement defaults topic
in the SAP IQ administration database
guide. The first required parameter is
the location and name of the database.
Enter the path as an absolute value. The
folders or directories in your path must
exist before you execute the command. At
the end of the path enter a slash and
named the database. Enclose the path in
quotes. Make sure you get the slashes in
the right direction as required for your
IQ server platform. Next enter the
default IQ username and password. It is
the only user initially created and is
granted all IQ system and object level
privileges in the database. Use a
password at the six characters long
containing upper and lowercase letters
and numbers. Again enclose each value in
quotes. Finally enter the storage
location of the IQ main DB space. It uses
the same absolute path and file name as
the database but with a dot IQ instead.
When you execute the statement if it
finds any errors a message appears with
a hint as to the problem. For my demo I
forgot the quotes around the DB space
value. So I'll add the quotes and try
again.
While the statement is executing the tab
shows a processing icon. It can take a
few minutes for creation to complete. But
when done it returns to the IQ server
icon.
And the files that make up the database
appear in the specified folder for the
IQ server platform. Once you have a
database you no longer need the utility
database running and you should shut it
down. To do this, in Windows, right click
or double click the utility database
icon and select shutdown. In UNIX type
stop underscore IQ and then type the
number of the utility database. After you
create the database you need to start it.
A database must be running to use it.
Watch the starting SAP IQ database
video to learn how.
If you want to learn more about SAP IQ
check out the IQ documentation on the
SAP help portal or watch videos on
other SAP IQ IQ tasks. Thanks for watching.