IQ 16如何使用外部LDAP Server进行身份认证_创建示例数据库

    为了说明IQ 16外部LDAPUA这种认证方式，我们需要准备一个IQ 16数据库。在这篇文章中，将向大家介绍IQ 16 Demo数据库的创建方法。
    1. 安装IQ 16.0 Server For Linux X86_64bit
        安装IQ 16.0 Server，具体的方法和步骤参见如下链接：
        http://blog.chinaunix.net/uid-16765068-id-3796019.html

    2. 创建IQ Demo数据库(假设安装IQ 16软件的操作系统账户是sybiq160
        具体的步骤如下：
         su - sybiq160
         cd $IQDIR16/demo
         ./mkiqdemo.sh          #执行这个shell脚本可以创建demo数据库
         下面是执行这个shell脚本的示例交互和输出信息：
[sybiq160@DBNode1 demo]$ ./mkiqdemo.sh

This script will create the iqdemo database in the current
directory.  An existing iqdemo database in this directory
will need to be shutdown and over-written.

Continue ? Y

Checking system ...

There are no servers running on this system

Starting Server ...

 

Starting server bld_demo_9761 on DBNode1 at port 9761 (03/13 13:54:23)

Run Directory       : /opt/sybiq/16.0/IQ-16_0/demo
Server Executable   : /opt/sybiq/16.0/IQ-16_0/bin64/iqsrv16
Server Output Log   : /opt/sybiq/16.0/IQ-16_0/logfiles/bld_demo_9761.0001.srvlog
Server Version      : 16.0.0.481/sp01
16.0.0/Linux 2.6.18-194.el5
Open Client Version : N/A
User Parameters     :
Default Parameters  : -gc 20 -gl all -ti 4400 -gn 25

I. 03/13 13:55:13. Sybase IQ
I. 03/13 13:55:13. Version 16.0
I. 03/13 13:55:13. (64bit mode)
I. 03/13 13:55:13. Copyright 1992-2013 by SAP AG or an SAP affiliate company. All rights reserved
I. 03/13 13:55:13. Copyright (c) 2013 SAP AG or an SAP affiliate company.
I. 03/13 13:55:13. All rights reserved.
I. 03/13 13:55:13. Use of this software is governed by the Sybase License Agreement.
I. 03/13 13:55:13. Refer to .
I. 03/13 13:55:13.
I. 03/13 13:55:13. Processors detected: 4
I. 03/13 13:55:13. Maximum number of processors the server will use: 4 physical processor(s), 4 core(s)
I. 03/13 13:55:13. Running Linux 2.6.18-128.el5 #1 SMP Wed Dec 17 11:41:38 EST 2008 on X86_64
I. 03/13 13:55:13. Server built for X86_64 processor architecture
I. 03/13 13:55:13. 49152K of memory used for caching
I. 03/13 13:55:13. Minimum cache size: 49152K, maximum cache size: 262144K
I. 03/13 13:55:13. Using a maximum page size of 4096 bytes
I. 03/13 13:55:13. Multiprogramming level: 25
I. 03/13 13:55:13. Automatic tuning of multiprogramming level is disabled
I. 03/13 13:55:14. Database server started at Wed Mar 13 2013 13:55
I. 03/13 13:55:14. Trying to start SharedMemory link ...
I. 03/13 13:55:14.     SharedMemory link started successfully
I. 03/13 13:55:14. Trying to start TCPIP link ...
I. 03/13 13:55:14. Starting on port 9761

=============================================================
IQ server starting with:
     10 connections         (       -gm )
     18 cmd resources       ( -iqgovern )
    257 threads             (     -iqmt )
    512 Kb thread stack size   (   -iqtss  )
  131584 Kb thread memory size ( -iqmt * -iqtss )
      4 IQ number of cpus  ( -iqnumbercpus )
      0 MB maximum size of IQMSG file ( -iqmsgsz )
      0 copies of IQMSG file archives ( -iqmsgnum )
=============================================================

I. 03/13 13:55:19.     TCPIP link started successfully
I. 03/13 13:55:19. Now accepting requests
New process id is 16199

Server started successfully

Started.
Connecting to server via TCPIP ...
Using: uid=DBA;pwd=sql;eng=bld_demo_9761;dbn=utility_db;links=tcpip{host=DBNode1;port=9761}

Creating database ...
Demo database created.

Shutting down server ...
SQL Anywhere Stop Server Utility Version 16.0.0.481

-rw-r--r-- 1 sybiq160 sybase       540 Mar 13 13:55 iqdemo.cfg
-r--r--r-- 1 sybiq160 sybase   3874816 Mar 13 13:55 iqdemo.db
-rw-r--r-- 1 sybiq160 sybase 104857600 Mar 13 13:55 iqdemo.iq
-rw-r--r-- 1 sybiq160 sybase     38863 Mar 13 13:55 iqdemo.iqmsg
-rw-r--r-- 1 sybiq160 sybase  26214400 Mar 13 13:55 iqdemo.iqtmp
-rw-r--r-- 1 sybiq160 sybase       409 Mar 13 13:55 iqdemo.lmp
-r-------- 1 sybiq160 sybase    327680 Mar 13 13:55 iqdemo.log
-rw-r--r-- 1 sybiq160 sybase 104857600 Mar 13 13:55 iqdemo_main.iq

Demo database created successfully