Instalar bancos de teste no Sybase ASE

O Sybase ASE 15.5 vem com dois bancos de dados teste, o pubs2 e o pubs 3.

Para instalar estes bancos, basta executar o script que é instalado no servidor.

[sybase@Sybase01 scripts]$ pwd
/opt/sybase/ASE-15_0/scripts
[sybase@Sybase01 scripts]$ ls -lh
total 9.4M
-rwxr-xr-x 1 sybase sybase 3.2K Aug 25 2010 checksvrsuids
drwxrwxr-x 2 sybase sybase 4.0K Mar 21 11:37 deckanji
drwxrwxr-x 2 sybase sybase 4.0K Mar 21 11:37 eucjis
-rw-r--r-- 1 sybase sybase 13K Aug 25 2010 hs_directload.sql
-rw-r--r-- 1 sybase sybase 296K Aug 25 2010 ins_syn_sql
-rw-r--r-- 1 sybase sybase 17K Aug 25 2010 installcommit
-rw-r--r-- 1 sybase sybase 232K Aug 25 2010 installdbccalt
-rw-r--r-- 1 sybase sybase 261K Aug 25 2010 installdbccdb
-rw-r--r-- 1 sybase sybase 363K Aug 25 2010 installdbextend
-rw-r--r-- 1 sybase sybase 996K Aug 25 2010 installhasvss
-rw-r--r-- 1 sybase sybase 572K Aug 25 2010 installjsdb
-rw-r--r-- 1 sybase sybase 5.2M Aug 25 2010 installmaster
-rw-r--r-- 1 sybase sybase 2.3K Aug 25 2010 installmodel
-rw-r--r-- 1 sybase sybase 1.5K Aug 25 2010 installmon
-rw-r--r-- 1 sybase sybase 66K Aug 25 2010 installmontables
-rw-r--r-- 1 sybase sybase 66K Aug 25 2010 installmsgsvss
-rw-r--r-- 1 sybase sybase 267K Aug 25 2010 installpcidb
-rw-r--r-- 1 sybase sybase 460K Aug 25 2010 installpix2
-rw-r--r-- 1 sybase sybase 43K Aug 25 2010 installpubs2
-rw-r--r-- 1 sybase sybase 52K Aug 25 2010 installpubs3
-rw-r--r-- 1 sybase sybase 92K Aug 25 2010 installsecurity
-rwxr-xr-x 1 sybase sybase 31K Aug 25 2010 installupgrade
-rw-r--r-- 1 sybase sybase 317K Aug 25 2010 instmsgs.ebf
drwxrwxr-x 2 sybase sybase 4.0K Mar 21 11:37 iso_1
drwxrwxr-x 2 sybase sybase 4.0K Mar 21 11:37 sjis
-rw-r--r-- 1 sybase sybase 52K Aug 25 2010 uninstmsgs.ebf
[sybase@Sybase01 scripts]$ isql -Usa -PNerv2011 -SSYBASE01 -iinstallpubs2
00:00:00000:00023:2011/03/22 21:07:50.36 server Timestamp for database 'pubs2' is (0x0000, 0x00001302).
Creating the "pubs2" database
CREATE DATABASE: allocating 1792 logical pages (7.0 megabytes) on disk 'master'
(1792 logical pages requested).
Database 'pubs2' is now online.
Database option 'trunc log on chkpt' turned ON for database 'pubs2'.
Running CHECKPOINT on database 'pubs2' for option 'trunc log on chkpt' to take
effect.
(return status = 0)
Type added.
(return status = 0)
Type added.
(return status = 0)
New primary key added.
(return status = 0)
New primary key added.
(return status = 0)
New primary key added.
(return status = 0)
New primary key added.
(return status = 0)
New primary key added.
(return status = 0)
New primary key added.
(return status = 0)
New primary key added.
(return status = 0)
New primary key added.
(return status = 0)
(return status = 0)
New foreign key added.
(return status = 0)
New foreign key added.
(return status = 0)
New foreign key added.
(return status = 0)
New foreign key added.
(return status = 0)
New foreign key added.
(return status = 0)
New foreign key added.
(return status = 0)
New foreign key added.
(return status = 0)
New foreign key added.
(return status = 0)
New foreign key added.
(return status = 0)
New foreign key added.
(return status = 0)
Default bound to column.
(return status = 0)
Default bound to column.
(return status = 0)
Default bound to column.
(return status = 0)
Rule bound to table column.
(return status = 0)
Rule bound to table column.
(return status = 0)
Rule bound to table column.
(return status = 0)
(return status = 0)
[sybase@Sybase01 scripts]$ isql -Usa -PNerv2011 -SSYBASE01 -iinstallpubs3
00:00:00000:00024:2011/03/22 21:08:10.00 server Timestamp for database 'pubs3' is (0x0000, 0x00001302).
Creating the "pubs3" database
CREATE DATABASE: allocating 1536 logical pages (6.0 megabytes) on disk 'master'
(1536 logical pages requested).
Database 'pubs3' is now online.
Database option 'trunc log on chkpt' turned ON for database 'pubs3'.
Running CHECKPOINT on database 'pubs3' for option 'trunc log on chkpt' to take
effect.
(return status = 0)
Type added.
(return status = 0)
Type added.
(return status = 0)
Default bound to column.
(return status = 0)
Default bound to column.
(return status = 0)
Default bound to column.
(return status = 0)
Rule bound to table column.
(return status = 0)
Rule bound to table column.
(return status = 0)
Rule bound to table column.
(return status = 0)
(return status = 0)
[sybase@Sybase01 scripts]$

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.