SAP Sybase Training Note 2

Source: Internet
Author: User
Tags dba sybase

1, consider the data planning, storage space and so on. estimated by formula; character set, sort, page size cannot be changed after creation. data storage planning, especially for cluster mode deploymentLUN Plan Essentials. the disk used by IQ must be physically isolated from other applications;RAID 5/6don't use LVM .dispersing I/O as far as possible1. We recommend patching and building the library first. 2. Preparing the file systemIt is recommended to allocate a separate file system such as database log information (SERVERLOG/IQMSG) to avoid the log explosion. start_iq-n iqdemo iqdemo.db ... <other options> ... -iqmsgsz 100-iqmsgnum 3 start_iq -n iqdemo iqdemo.db  ....  <other options> ... -iqmsgsz!--wizrtf2html charset=0-->A  -iqmsgnum Value n greater than 0 means that the server maintains n message log Archi Ves. For example, this command specifies that the server maintain 3 archives of the message log

Use THE-IQMSGSZ and-iqmsgnum switches to prevent the message log file from growing indefinitely

-iqmsgsz (MB)
0 = default, which means there is no limit on the size of the message log file.
0 < x <= 2047, Limit on the size of the message log file.


-iqmsgnum
0 = default, which means that messages be wrapped in the main message log file and there is no archiving
0 < x <=, sets the number of message log archives


Source: http://solveissue.com/note?id=1979551



3, ready to bare equipment (optional, cluster required)under Linux, Dev/raw/rawxxxall nodes under the cluster must have access to the shared bare device.  >start_iq-n utility_db-n utility_db "-GP 8192">dbisql-c "uid=dba;pwd=sql;eng=utility_db;dbn=utility_db"-noguiCREATE database ' f:\temp\test.db '--Must be full pathIQ PATH ' f:\temp\iq_system_main.iq '--Soft linkIQ SIZEIQ PAGE SIZE 131072temporary PATH ' xxx.iqtmp '--Soft linkTemporary sizeMESSAGE PATH ' xxx.iqmsg '--- modifiableLOG on ' F:\TEST. LOG '---repairablePage Size 8192collation ' Euc_china '---character set or cp936BLANK PADDING onCase IGNORE;Building Services:>dbisql-c "uid=dba;pwd=sql;eng=utility_db;dbn=utility_db"-nogui>h:\sybase>create DATABASE ' h:\SYBASE\T1\t1.db ' LOG on ' h:\SYBASE\T1 ' PAGE SIZE 4096 IQ PATH ' SYSTEM. IQ ' IQ size: ' IQ PAGE size 4096 temporary path ' h:\SYBASE\T1\t1.iqtmp ' temporary size $ MESSAGE PATH ' h:\SYBASE\T1\t1. Iqmsg ' collation ' Euc_china ' BLANK PADDING on Case IGNORE>start_iq t2.dbParameters:the size of the IQ page Size:iq store. default 128koptional up toShared Memory:Local administration by: Dbisql-c ' uid=dba;p wd=sql;eng=t2 'dbisql-c ' uid=dba;p wd=sql;commlinks=tcpip{host=localhost:26} 'TCP/IP protocol. dbisqlc-c ',, Eng=eptgdev2_iqdemo '-Q load.sql----------------------------dbisql-c ""-host-port-noguiJDBCJar PackageDbisql is generally a management applicationentire database size and CPU to configureA check should be 8G of memory, device size and number based on the amount of data and CPU to configure. Number of devices/10+3 such as: 8 nuclear 8/10+3. =4 Devicesproduction Environment Iq_system_main is the 20% of User_dbspace. Building Space: (DBA) > Create dbspace user_ds using file ds_f1 ' us1.iq ' sizeexecution time:0.273 seconds(DBA) > Alter dbspace user_ds Add File ds_f2 ' us2.iq ' sizeexecution time:0.158 seconds(DBA) > Alter dbspace user_ds Add File ds_f3 ' us3.iq ' sizeexecution time:0.192 secondsmigrating data. Delete the database space. >alter dbspace iq_system_temp Add File ds_temp ' h:\sybase\t1\db_temp.iq ' size;>create table T1 (f_id int,f_value char) in User_ds;>insert into T1 values (1, ' xx ');>insert into T1 values (2, ' yy ');>commit>alter DBSPACE user_ds alter file ds_f3 readonly;>sp_iqemptyfile ' ds_f3 ';>alter dbspace user_ds drop file ds_f3;>select * from T1Set Server parameters:You can rename the default.cfg copy in the script folder in the demo library to Params.cfg. The contents are as follows===============================================================================================- N T2- x tcpip{port=2688}4-8 times the-ch. db file-CL. Try to match the size of. DB- C 128m--CTR (Catlog cache, production system General 128M,. Try to match the size of. db)-GC-GD All--permissions, closing load data, etc.-GL All-GM-gp 4096--catlog page size-ti 4400-IQMC 500--cache of data-IQTC 500--The larger the cache of temporary data, the better.-IQLM 500--16, a memory base based on row-type storage. -iqmsgsz-iqmsgnum 3- o h:\\sybase\\t1\\t2.svrlog================================================================================================>start_iq @params. CFG Add database Users two ways:Grant connect to U1 identified by ' 123456 ';Sp_iqaddlogin ' U2 ', ' sap123456 ';----note letters plus numbersa series of actions for groups and usersGrant connect to marketing;..... Grant execute on sp_iqlocks to U1Set stored procedure execution permissions. RevokeIQ Non-chained, open client connection, no explicit commit required. DML still commits: Insert/delete and so on, or commit. Iq:olap;IQ is not recommended for business systems.reading does not affect writing, writing does not affect reading. Backup Recovery: FullIncrementalIncremental-since-fullbackup database to '/dev/rmt/0n 'Backup DatabaseIncremental tosp_iqcheckdb ' allocation database ';--check databases, data fragments, etc. This check is done before the backup to avoid accumulating a fatal error. Virtual Backup :Nonstopiq:sybase IQ's Disaster recovery method:provides fast backup recovery with the hardware features of the disk array and the software characteristics of Sybase IQ.

From for notes (Wiz)

SAP Sybase Training Note 2

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.