Criar banco de exemplo no Sybase IQ

[sybase@SybaseIQ01 ~]$ export SYBASE=/opt/sybase
[sybase@SybaseIQ01 ~]$ . /opt/sybase/SYBASE.sh
[sybase@SybaseIQ01 ~]$ . $SYBASE/IQ-15_4/IQ-15_4.sh
Sourcing SYBASE.sh
[sybase@SybaseIQ01 ~]$ cd $IQDIR15/demo
[sybase@SybaseIQ01 demo]$ sh ./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_9247 on SybaseIQ01 at port 9247 (05/30 16:07:52)

Run Directory       : /opt/sybase/IQ-15_4/demo
Server Executable   : /opt/sybase/IQ-15_4/bin64/iqsrv15
Server Output Log   : /opt/sybase/IQ-15_4/logfiles/bld_demo_9247.0001.srvlog
Server Version      : 15.4.0.6567/GA
Open Client Version : N/A
User Parameters     : '@bld_demo_9247.cfg'
Default Parameters  : -gc 20 -gl all -ti 4400 -gn 25

I. 05/30 16:07:55. Sybase IQ
I. 05/30 16:07:55. Version 15.4
I. 05/30 16:07:55. (64bit mode)
I. 05/30 16:07:55. Copyright 1992-2011 by Sybase, Inc. All rights reserved
I. 05/30 16:07:55. Copyright (c) 2001-2011, Sybase, Inc.
I. 05/30 16:07:55. Portions copyright (c) 1988-2011, iAnywhere Solutions, Inc. All rights reserved.
I. 05/30 16:07:55. Use of this software is governed by the Sybase License Agreement.
I. 05/30 16:07:55. Refer to http://www.sybase.com/softwarelicenses.
I. 05/30 16:07:55.
I. 05/30 16:07:55. Processors detected: 1
I. 05/30 16:07:55. Maximum number of physical processors the server will use: 1
I. 05/30 16:07:55. Running Linux 2.6.32-220.17.1.el6.x86_64 #1 SMP Wed May 16 00:01:37 BST 2012 on X86_64
I. 05/30 16:07:55. Server built for X86_64 processor architecture
I. 05/30 16:07:55. 49152K of memory used for caching
I. 05/30 16:07:55. Minimum cache size: 49152K, maximum cache size: 184588K
I. 05/30 16:07:55. Using a maximum page size of 4096 bytes

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

I. 05/30 16:07:55. Database server started at Wed May 30 2012 16:07
I. 05/30 16:07:55. Trying to start SharedMemory link ...
I. 05/30 16:07:55.     SharedMemory link started successfully
I. 05/30 16:07:55. Trying to start TCPIP link ...
I. 05/30 16:07:55. Starting on port 9247
I. 05/30 16:08:00.     TCPIP link started successfully
I. 05/30 16:08:00. Now accepting requests
New process id is 1283

Server started successfully

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

Creating database ...
Demo database created.

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

-rw-rw-r--. 1 sybase sybase       539 May 30 16:08 iqdemo.cfg
-r--r--r--. 1 sybase sybase   3899392 May 30 16:08 iqdemo.db
-rw-r--r--. 1 sybase sybase 104857600 May 30 16:08 iqdemo.iq
-rw-r--r--. 1 sybase sybase     41122 May 30 16:08 iqdemo.iqmsg
-rw-r--r--. 1 sybase sybase  26214400 May 30 16:08 iqdemo.iqtmp
-rw-rw-r--. 1 sybase sybase       393 May 30 16:08 iqdemo.lmp
-r--------. 1 sybase sybase    327680 May 30 16:08 iqdemo.log
-rw-r--r--. 1 sybase sybase 104857600 May 30 16:08 iqdemo_main.iq

Demo database created successfully

[sybase@SybaseIQ01 demo]$

2 comments

  1. bom dia,
    eu tenho um arquivo de 400 mil linhas de insert. Como faço para executar ele? pois o sql interactive não abre.
    no oracle pelo sqlplus eu sei que é com @enderço.sql.

Leave a Reply

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *

Esse site utiliza o Akismet para reduzir spam. Aprenda como seus dados de comentários são processados.