Reorganizando uma Instancia - Informix
Uma instancia do Informix foi definida para ficar todos os bancos usando uma dbspace especifica;
+------------+-----------------+----------+
| Dbspace | Database | Space |
+------------+-----------------+----------+-----------+
| rootdbs | syscdr | | Bancos |
| rootdbs | sysutils | | |
| rootdbs | sysuser | | |
| rootdbs | sysadmin | 35 Gb | SYS* |
+------------+-----------------+----------+-----------+
| phydbs | | 20 Gb |
+------------+-----------------+----------+
| tmp1dbs | | 50 Gb |
| tmp2dbs | | 50 Gb |
+------------+-----------------+----------+
| logdbs | | 5 Gb |
+------------+-----------------+----------+-----------+
| usrdbs | Auditoria | 800 Gb | Bancos |
| usrdbs | tributario | 600 GB | |
| usrdbs | etl_dw | 400 Gb | de |
| usrdbs | desenv | 20 Gb | |
| usrdbs | gql | 20 Gb | Produção |
+------------+-----------------+----------+-----------+ +------------+-----------------+----------+
| Dbspace | Database | Space |
+------------+-----------------+----------+-----------+
| rootdbs | syscdr | | Bancos |
| rootdbs | sysutils | | |
| rootdbs | sysuser | | |
| rootdbs | sysadmin | 35 Gb | SYS* |
+------------+-----------------+----------+-----------+
| phydbs | | 20 Gb |
+------------+-----------------+----------+
| tmp1dbs | | 50 Gb |
| tmp2dbs | | 50 Gb |
+------------+-----------------+----------+
| logdbs | | 5 Gb |
+------------+-----------------+----------+-----------+
| aud_dbs | Auditoria | 800 Gb | Bancos |
+------------+-----------------+----------+ |
| trb_dbs | tributario | 600 Gb | |
+------------+-----------------+----------+ |
| etl_dbs | etl_dw | 400 Gb | de |
+------------+-----------------+----------+ |
| des_dbs | desenv | 20 Gb | |
+------------+-----------------+----------+ |
| gql_dbs | gql | 20 Gb | Produção |
+------------+-----------------+----------+-----------+[xUnion:informix]$/export/home/informix/ su root
Password:
[xUnion:root]#/export/home/informix> cd /opt
[xUnion:root]#/opt> mkdir informix1170FC2
[xUnion:root]#/opt> ln -s informix1170FC2 informix
[xUnion:informix]$/opt/informix> tar -xvf IIF_11.70.FC2_linux_64.tar[xUnion:root]#/opt/informix> ./ids_install
Preparing to install...
Extracting the JRE from the installer archive...
Unpacking the JRE...
Extracting the installation resources from the installer archive...
Configuring the installer for this system's environment...
Launching installer...
Preparing CONSOLE Mode Installation...
===============================================================================
IBM Informix Software Bundle (created with InstallAnywhere)
-------------------------------------------------------------------------------===============================================================================
Getting started with IBM Informix Software Bundle
-------------------------------------------------
InstallAnywhere will guide you through the installation of IBM Informix
Software Bundle.
1. Release Notes
The Release Notes can be found in
/opt/informix1170FC2/server/doc/ids_unix_relnotes_11.70.html
2. Installation Guide
Please view the Installation / Quick Beginnings Guide at
/opt/informix1170FC2/server/doc/ids_unix_installg_11.70.pdf
3. Launch Information Center
Access the IDS 11.70 Information Center at
http://publib.boulder.ibm.com/infocenter/idshelp/v117/index.jsp
To Begin Installation,
Respond to each prompt to proceed to the next step in the installation.
If you want to change something on a previous step, type 'back'.
You may cancel this installation at any time by typing 'quit'.
PRESS TO CONTINUE: ===============================================================================
International Program License Agreement
Part 1 - General Terms
BY DOWNLOADING, INSTALLING, COPYING, ACCESSING, CLICKING ON AN
"ACCEPT" BUTTON, OR OTHERWISE USING THE PROGRAM, LICENSEE AGREES TO
THE TERMS OF THIS AGREEMENT. IF YOU ARE ACCEPTING THESE TERMS ON
BEHALF OF LICENSEE, YOU REPRESENT AND WARRANT THAT YOU HAVE FULL
AUTHORITY TO BIND LICENSEE TO THESE TERMS. IF YOU DO NOT AGREE TO
THESE TERMS,
- DO NOT DOWNLOAD, INSTALL, COPY, ACCESS, CLICK ON AN "ACCEPT" BUTTON,
OR USE THE PROGRAM; AND
- PROMPTLY RETURN THE UNUSED MEDIA, DOCUMENTATION, AND PROOF OF
ENTITLEMENT TO THE PARTY FROM WHOM IT WAS OBTAINED FOR A REFUND OF THE
AMOUNT PAID. IF THE PROGRAM WAS DOWNLOADED, DESTROY ALL COPIES OF THE
PROGRAM.
Press Enter to continue viewing the license agreement, or enter "1" to
accept the agreement, "2" to decline it, "3" to print it, "4" to read
non-IBM terms, or "99" to go back to the previous screen.: 1===============================================================================
Installation Goals
------------------
What do you want to accomplish?
->1- Install products and features
2- Extract the product files (-DLEGACY option)
3- Create an RPM image for redistribution
ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS TO ACCEPT THE DEFAULT:: ===============================================================================
Installation Location
---------------------
Choose location for software installation
Default Install Folder: /opt/informix
ENTER AN ABSOLUTE PATH, OR PRESS TO ACCEPT THE DEFAULT
: ===============================================================================
Installation Type
-----------------
Select the installation type.
Typical: Install the database server with all features and a database server that
is configured with default values. Includes:
** Client Software Development Kit (CSDK)
** Java Database Connectivity (JDBC)
Minimum disk space required: 700-800MB
Custom: Install the database server with specific features and software that you need.
Optionally install a configured database server instance.
Minimum disk space required: 75 MB (without a server instance)
->1- Typical
2- Custom
ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS TO ACCEPT THE DEFAULT:: ===============================================================================
Server Instance Creation
------------------------
Create a server instance?
->1- Yes - create an instance
2- No - do not create an instance
ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS TO ACCEPT THE DEFAULT:: 2 ===============================================================================
Installation Summary
--------------------
Please review the following before continuing:
Product Name:
IBM Informix Software Bundle
Install Folder:
/opt/informix
Product Features:
IBM Informix database server,
Base Server,
Extensions and tools,
J/Foundation,
Database extensions,
Conversion and reversion support,
XML publishing,
Demonstration database scripts,
Enterprise Replication,
Data loading utilities,
onunload and onload utilities,
dbload utility,
High-Performance Loader,
Backup and Restore,
archecker utility,
ON-Bar utility,
Informix Storage Manager,
Informix interface to Tivoli Storage Manager,
Administrative utilities,
Performance monitoring utilities,
Miscellaneous monitoring utilities,
Auditing utilities,
Database import and export utilities,
IBM Informix Client SDK,
IBM Informix Object Interface for C++,
IBM Informix Object Interface for C++ demos,
IBM Informix ESQL/C,
7.2 application compatibility module,
IBM Informix ESQL/C demos,
IBM Informix LIBDMI for client applications,
IBM Informix ODBC Driver,
IBM Informix ODBC Driver demos,
Global Language Support (GLS),
West European and Americas,
East European and Slavic,
Japanese,
Korean,
Chinese,
Thai,
IBM Informix JDBC
Disk Space Information (for Installation Target):
Required: 579,278,432 bytes
Available: 145,188,388,864 bytes
PRESS TO CONTINUE: ===============================================================================
Ready To Install
----------------
InstallAnywhere is now ready to install IBM Informix Software Bundle onto your
system at the following location:
/opt/informix
PRESS TO INSTALL: ===============================================================================
Installing...
-------------
[==================|==================|==================|==================]
[------------------|------------------|------------------|------------------]===============================================================================
Installation Complete
---------------------
Congratulations! IBM Informix Software Bundle installation is complete.
Product install status:
IBM Informix 11.70: Successful
IBM Informix Client-SDK: Successful
IBM Informix JDBC Driver: Successful
PRESS TO EXIT THE INSTALLER:
[xUnion:root]#/opt/informix> [xUnion:informix]$/export/home/informix> cp onconfig /opt/informix/etc
[xUnion:informix]$/export/home/informix> cp sqlhosts /opt/informix/etc[xUnion:informix]$/export/home/; oninit -i
Reading configuration file '/opt/informix/etc/onconfig'...succeeded
Creating /export/home/informix/space/.infxdirs...succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 81858 kbytes...succeeded
Allocating 40016 kbytes for buffer pool of 2K page size...succeeded
Allocating 4328016 kbytes for buffer pool of 16K page size...succeeded
Creating infos file "/opt/informix/etc/.infos.permanente_db"...succeeded
Linking conf file "/opt/informix/etc/.conf.permanente_db"...succeeded
Initializing rhead structure...succeeded
Writing to infos file...succeeded
Initialization of Encryption...succeeded
Initializing ASF...succeeded
Initializing Dictionary Cache and SPL Routine Cache...succeeded
Bringing up ADM VP...succeeded
Creating VP classes...succeeded
Onlining 2 additional cpu vps...succeeded
Onlining 3 IO vps...succeeded
Forking main_loop thread...succeeded
succeeded
Forking 1 'soctcp' listener threads...succeeded
Starting tracing...succeeded
Initializing 50 flushers...succeeded
Initializing SDS Server network connections...succeeded
Initializing log/checkpoint information...succeeded
Initializing dbspaces...succeeded
Opening primary chunks...succeeded
Opening mirror chunks...succeeded
Validating chunks...succeeded
Initialize Async Log Flusher...succeeded
Starting B-tree Scanner...succeeded
Initializing DBSPACETEMP list...succeeded
Initializing dataskip structure...succeeded
Checking for temporary tables to drop...succeeded
Updating Global Row Counter...
Forking onmode_mon thread...succeeded
Creating periodic thread...succeeded
Starting scheduling system...succeeded
Verbose output complete: mode = 505/22/10 11:03:58 On-Line Mode
05/22/10 11:03:59 SCHAPI: Started dbScheduler thread.
05/22/10 11:03:59 Auto Registration is synced
05/22/10 11:03:59 Booting Language from module <>
05/22/10 11:03:59 Loading Module
05/22/10 11:03:59 SCHAPI: Started 2 dbWorker threads.
05/22/10 11:04:02 Defragmenter cleaner thread now running
05/22/10 11:04:02 Defragmenter cleaner thread cleaned:0 partitions
05/22/10 11:04:59 Loading Module <$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld>
05/22/10 11:04:59 The C Language Module loaded chown informix:informix /dev/sdb2
chmod 660 /dev/sdb2
ln -s /dev/sdb2 /dev/informix/tmp1_dbs
touch /dev/informix/tmp1_dbs
chmod 660 /dev/informix/tmp1_dbs
chown informix:informix /dev/informix/tmp1_dbs
onspaces -c -d tmp1dbs -t -p /dev/informix/tmp1_dbs -s 52428800 -o 0 -k 16chown informix:informix /dev/sdb3
chmod 660 /dev/sdb3
ln -s /dev/sdb3 /dev/informix/tmp2_dbs
touch /dev/informix/tmp1_dbs
chmod 660 /dev/informix/tmp1_dbs
chown informix:informix /dev/informix/tmp1_dbs
onspaces -c -d tmp1dbs -t -p /dev/informix/tmp1_dbs -s 52428800 -o 0 -k 16chown informix:informix /dev/sdb6
chmod 660 /dev/sdb6
ln -s /dev/sdb6 /dev/informix/logdbs
touch /dev/informix/logdbs
chmod 660 /dev/informix/logdbs
chown informix:informix /dev/informix/logdbs
onspaces -c -d logdbs -p /dev/informix/logdbs -o 0 -s 5242880chown informix:informix /dev/sdb7
chmod 660 /dev/sdb7
ln -s /dev/sdb7 /dev/informix/aud_dbs
touch /dev/informix/aud_dbs
chmod 660 /dev/informix/aud_dbs
chown informix:informix /dev/informix/aud_dbs
onspaces -c -d aud_dbs -p /dev/informix/aud_dbs -s 838860800 -o 0 -k 16chown informix:informix /dev/sdb8
chmod 660 /dev/sdb8
ln -s /dev/sdb8 /dev/informix/trb_dbs
touch /dev/informix/trb_dbs
chmod 660 /dev/informix/trb_dbs
chown informix:informix /dev/informix/trb_dbs
onspaces -c -d trb_dbs -p /dev/informix/trb_dbs -s 629145600 -o 0 -k 16chown informix:informix /dev/sdb9
chmod 660 /dev/sdb9
ln -s /dev/sdb9 /dev/informix/etl_dbs
touch /dev/informix/etl_dbs
chmod 660 /dev/informix/etl_dbs
chown informix:informix /dev/informix/etl_dbs
onspaces -c -d etl_dbs -p /dev/informix/etl_dbs -s 419430400 -o 0 -k 16chown informix:informix /dev/sdb10
chmod 660 /dev/sdb10
ln -s /dev/sdb10 /dev/informix/des_dbs
touch /dev/informix/des_dbs
chmod 660 /dev/informix/des_dbs
chown informix:informix /dev/informix/des_dbs
onspaces -c -d des_dbs -p /dev/informix/des_dbs -s 20971520 -o 0 -k 16chown informix:informix /dev/sdb11
chmod 660 /dev/sdb11
ln -s /dev/sdb11 /dev/informix/gql_dbs
touch /dev/informix/gql_dbs
chmod 660 /dev/informix/gql_dbs
chown informix:informix /dev/informix/gql_dbs
onspaces -c -d gql_dbs -p /dev/informix/gql_dbs -s 20971520 -o 0 -k 16[xUnion:informix]$/export/home/informix> vi create_llog.sqlCT=1
LIMIT=80
while [ "$CT" -lt "$LIMIT" ]
do
echo $CT
onparams -a -d logdbs -s 102400;
let "CT +=1"
done[xUnion:informix]$/export/home/informix> chmod 755 create_llog.sql
[xUnion:informix]$/export/home/informix> ./create_llog.sqlChunks
address chunk/dbs offset size free bpages flags pathname
159e211d0 1 1 0 18350080 18316759 PO-B-- /dev/informix/rootdbs
15c304378 2 2 0 3276800 3276747 PO-B-- /dev/informix/tmp1_dbs
15c304578 3 3 0 3276800 3276747 PO-B-- /dev/informix/tmp2_dbs
15c304778 4 4 0 10485760 10485707 PO-B-- /dev/informix/phydbs
15c304978 5 5 0 2621440 10187 PO-B-- /dev/informix/logdbs
15c304b78 6 6 0 52428800 52428747 PO-B-- /dev/informix/aud_dbs
15c304d78 7 7 0 39321600 39321547 PO-B-- /dev/informix/trb_dbs
15c306028 8 8 0 26214400 26214347 PO-B-- /dev/informix/etl_dbs
15c306228 9 9 0 1310720 1310667 PO-B-- /dev/informix/des_dbs
15c306428 10 10 0 1310720 1133297 PO-B-- /dev/informix/gql_dbs
10 active, 32766 maximumChunks
address chunk/dbs offset size free bpages flags pathname
15821e1d0 1 1 0 18350080 18066171 PO-B-D /dev/sdb20
15a855028 2 2 0 3276800 3271193 PO-B-- /dev/sdb21
15a855228 3 3 0 3276800 3271197 PO-B-- /dev/sdb22
15a855428 4 4 0 10485760 524260 PO-B-D /dev/sdb23
15a855628 5 5 0 2621440 10212 PO-B-D /dev/sdb24
15a855828 6 6 0 34078720 262831 PO-B-D /dev/sdb25
15a855a28 7 6 0 34078720 2335458 PO-B-D /dev/sdb26
15a855c28 8 6 0 4966626 150616 PO-B-D /home/informix/pool/nx2009_usrdbs_fisico_1
15a855e28 9 6 0 1310720 117589 PO-B-D /home/informix/pool/nx2009_usrdbs_fisico_2
15a856028 10 6 0 655360 97931 PO-B-D /home/informix/pool/nx2009_usrdbs_fisico_3
15a856228 11 6 0 1310720 175558 PO-B-D /home/informix/pool/nx2009_usrdbs_fisico_4
15a856428 12 6 0 1638400 126094 PO-B-D /home/informix/pool/nx2009_usrdbs_fisico_5
15a856628 13 6 0 2949120 409723 PO-B-D /home/informix/pool/nx2009_usrdbs_fisico_6
15a856828 14 6 0 22020096 15405876 PO-B-D /home/informix/pool/nx2009_usrdbs_fisico_7
14 active, 32766 maximum[xUnion:root]#/tmp> rpm -ivh pigz-2.1.6-1.el6.rf.x86_64.rpm
warning: pigz-2.1.6-1.el6.rf.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 6b8d79e6: NOKEY
Preparing... ########################################### [100%]
1:pigz ########################################### [100%]
[xUnion:root]#/tmp>
[xUnion:root]#/tmp> rpm -ql pigz
/usr/bin/pigz
/usr/bin/unpigz
/usr/share/doc/pigz-2.1.6
/usr/share/doc/pigz-2.1.6/README
/usr/share/doc/pigz-2.1.6/pigz.pdf
/usr/share/man/man1/pigz.1.gz
[xUnion:root]#/tmp>
[xUnion:root]#/tmp>
[xUnion:root]#/tmp> rpm -ql pigz
/usr/bin/pigz
/usr/bin/unpigz
/usr/share/doc/pigz-2.1.6
/usr/share/doc/pigz-2.1.6/README
/usr/share/doc/pigz-2.1.6/pigz.pdf
/usr/share/man/man1/pigz.1.gz
[xUnion:root]#/tmp>
[xUnion:root]#/tmp>
[xUnion:root]#/tmp> pigz
Usage: pigz [options] [files ...]
will compress files in place, adding the suffix '.gz'. If no files are
specified, stdin will be compressed to stdout. pigz does what gzip does,
but spreads the work over multiple processors and cores when compressing.
Options:
-0 to -9, --fast, --best Compression levels, --fast is -1, --best is -9
-b, --blocksize mmm Set compression block size to mmmK (default 128K)
-p, --processes n Allow up to n compression threads (default is the
number of online processors, or 8 if unknown)
-i, --independent Compress blocks independently for damage recovery
-R, --rsyncable Input-determined block locations for rsync
-d, --decompress Decompress the compressed input
-t, --test Test the integrity of the compressed input
-l, --list List the contents of the compressed input
-f, --force Force overwrite, compress .gz, links, and to terminal
-r, --recursive Process the contents of all subdirectories
-S, --suffix .sss Use suffix .sss instead of .gz (for compression)
-z, --zlib Compress to zlib (.zz) instead of gzip format
-K, --zip Compress to PKWare zip (.zip) single entry format
-k, --keep Do not delete original file after processing
-c, --stdout Write all processed output to stdout (won't delete)
-N, --name Store/restore file name and mod time in/from header
-n, --no-name Do not store or restore file name in/from header
-T, --no-time Do not store or restore mod time in/from header
-q, --quiet Print no messages, even on error
-v, --verbose Provide more verbose output
[xUnion:root]#/tmp>BACKUP_FILTER /usr/bin/pigz
RESTORE_FILTER /usr/bin/unpigz- É obrigatório acesso unico e exclusivo ao banco de dados para o usuário que irá exportar o banco.
- Se houver algum usuário conectado no banco a exportação não irá ocorrer.
- Para exportação dos formatos de data é utilizado as variáveis de ambiente DBDATE, GL_DATETIME e USE_DTENV.
- A performance irá depender principalmente do I/O de disco onde os dados estão alocados e onde serão gerados.
- Para melhorar performance pode-se utilizar recurso de paralelismo se definido a variável PDQPRIORITY entre outras configurações de conectividade.
- Não é salvo: ultimo valor de campo SERIAL e modo de log do banco de dados
- São exportados todas as informações, como: tabelas, indices, sequences, roles, grants, estatisticas, triggers, stored procedures e etc.
- Configurações da Instancia (ONCONFIG) e dbspaces não são exportados pois não fazem parte do banco de dados, eles estão "acima" do banco.
Ao exportar uma base de dados o dbexport irá salvar todos os dados em um diretório, o nome deste diretório é o nome da base mais a extenção ".exp", durante a execução ele irá exibir o script dos objetos que estão sendo exportados.
- No servidor antigo - Iniciando o backup dos bancos de produção
dbexport -d auditoria -si
dbexport -d tributario -si
dbexport -d etl_dw -si
dbexport -d desenv -si
dbexport -d gql -sidbimport auditoria -d aud_dbs
dbimport tributario -d trb_dbs
dbimport etl_dw -d etl_dbs
dbimport desenv -d des_dbs
dbimport gql -d gql_dbs- Update Statistic - Ok
- Backup Onbar da Instancia - Ok
- Sincronizar contas; Ok
- Copiar passwd e shadow; Ok
- Sincronizar diretorios dos usuários; Ok
- Alterar o IP (do servidor velho) e do servidor novo; Ok
- Desligar o servidor antigo. Ok
- Reiniciar o novo servidor. Ok
- Compactar as tabelas para aumentar o espaço livre - (futuramente com calma - vou fazer);
- Testar o backup Logical Log - ok testado;
- Liberado os analistas testes - Ok;
- Liberada para produção - Ok;
Olá.
ResponderEliminarPorque quando tento criar um novo dbspace apresenta o erro sendo que eu ja criei o arquivo
-rw-rw---- 1 informix informix 0 Dec 15 18:45 chunk.001
# onspaces -c -d dadosdbs -p /database/dadosifx/tst/chunk.001 -s 7500000 -o 0
The file /database/dadosifx/tst/chunk.001 does not exist.
Você não postou um ls -la ou um pwd na pasta onde você criou o arquivo para eu checar o endereço, o comando em esta correto confirme realmente se o nome da pasta esta correto, tente dar um ls -la /database/dadosifx/tst/chunk.001 para ver se consegue achar este arquivo.
ResponderEliminarLembrei de uma coisa Adriano, eu usei neste exemplo as criações das dbspaces como raw device, acho que você quer usar como cooked file;
ResponderEliminarCriando como raw device
chown informix:informix /dev/sda3
chmod 660 /dev/sda3
ln -s /dev/sda3 dbspace1_chunk1
onspaces -c -d dbspace1 -p /u2/informix/STORAGE/dbspace1_chunk1 -o 0 -s 100000000
criando como cooked file
touch /home/informix/chunks/DATADBS01.01
chmod 660 /home/informix/chunks/DATADBS01.01
onspaces -c -d datadbs01 -p /home/informix/chunks/DATADBS01.01 -o 0 -s 4194304