01. Installation, Patch, Upgrade
Altibase Client Installation
Starting from ALTIBASE HDB 5.5.1
Altibase Server Patch Procedure on Unix and Linux
What Platforms (OS) Altibase HDB supports?
What to do when installing Altibase on Windows, and it says "It has already been installed"
02. Operation and Management
[Linux] How to register Altibase server process auto start script
Altibase Server Configuration for IPC Communication
Automatic altibase startup during OS booting in Solaris
Can PUBLIC SYNONYM be dropped?
Can table data be saved on disk and only indexes can be created in memory?
Database Security Checklist
Detailed procedure for changing character set
How to change sys user password
How to change the database's db name
How to change the path of log anchor, online log file, archive log file, and double write file
How to change the tablespace data file path
How to check the history of adding datafiles
How to create and execute Job objects
How to create a user (CREATE USER) and change a password (ALTER USER)
How to forcefully close a session that is being locked
How to modify column
How to resolve when LOCK TIMEOUT occurs
How to start and stop the database
How to startup Altibase automatically when booting from HP-UX
Maximum Capacity Specifications for Altibase
Notes/Considerations when changing TRANSACTION_TABLE_SIZE
Notes/Considerations when increasing the number of concurrent connection sessions (MAX_CLIENT)
Notes on using floating point data type (double, float)
User password length limitation - Differences by version
What is MEM_MAX_DB_SIZE?
When log disk is FULL and its countermeasures
When server create errors occur after DB name change
Causes and Solutions of Replication Conflicts
DDL operation on the table for Altibase replication
How to add/delete replication target table
How to change replication object IP
How to create/delete replication objects
How to create multiple replication objects with the same IP
Replication monitoring query
04. Backup and Recovery
How to recover cold backup by changing directory path
Online Backup and Time Based Recovery
Using aexport and iloader
Create database object and upload data
Database object backup using aexport
Data download using iloader
What is aexport, iloader?
Comparison between VARCHAR and CHAR types
How to check the privileges granted to an object
06. Stored Procedure
How to check the contents of stored procedure
How to check the number of records affected by DML within the stored procedure
07. Development and API
Connection disconnection, error codes, and error messages in each case (APRE*C/C++, SQLCLI)
How to manage Spring+iBatis transaction
How to change the jdbc.trc file creation location
How to use Fail-Over in Altibase JDBC
32-bit ODBC installation on 64-bit Windows
Integrating with unix_odbc
ODBC function, SQLFreeStmt
Hangul is broken when using php
Disk table and index usage
ALTIBASE HDB 4.3.9.x
ALTIBASE HDB 5.1.5.x
ALTIBASE HDB 5.3.x, 5.5.1, 6.1.1, 6.3.1
Disk tablespace usage
ALTIBASE HDB 4.3.9
ALTIBASE HDB 5.1.5
ALTIBASE HDB 5.3.3, 5.3.5
ALTIBASE HDB 5.5.1, 6.1.1, 6.3.1
How to determine which queries are being rolled back
How to log queries performed in Altibase (altiProfile)?
How to set up and execute altimon
Lock related properties
Memory table and index usage
Memory tablespace usage
ALTIBASE HDB 5.5.1, 6.1.1, 6.3.1
Monitoring Tools for Windows
System information by OS
Monitoring method when undo tablespace usage increases
Undo tablespace usage
09. Error Messages
[Notify : Fetch Timeout] Session Closed by Server.
[Warning] Memory allocation failed.
altibase_boot.log - TRY_COUNT, LOCK_COUNT, MISS_COUNT
Closed Socket by client is Detected
ERR-0109D Insufficient memory.
ERR-311E0 The estimated size of the index key exceeds the maximum limit.
ERR-410D2 (266450) Fetch out of sequence.
ERR-1105D Unable to begin a new update statement.
ERR-4103C (266300) Request of fetching data to an unprepared SQL statement.
ERR-4109C Invalid session property.
ERR-5102E ( 331822) Invalid cursor state.
ERR-7101D ( 462877) Protocol header error.
ERR-11030 ( 69680) The data file cannot be extended because the requested size is bigger than the maximum size (FID:<0%d>).
ERR-11036 The data file is in use.
ERR-11049 ( 69705) Too many pages are allocated ( Maximum Number of Pages= #).
ERR-11075 The transaction has exceeded the lock timeout specified by the user.
ERR-11118 ( 69912) The update log size '?????' is bigger than TRX_UPDATE_MAX_LOGSIZE '?????'
ERR-11183 ( 70019) Insufficient page descriptor area in the temp table.
ERR-11184 ( 70020) Insufficient free space in work area
ERR-21010 Value overflow.
ERR-21011 : Invalid literal
ERR-31283 Unable to create a primary key or a unique key constraint in the local non-prefixed index.
ERR-41059 ( 266329) Task pool overflow. Check properties.
ERR-71018 ( 462872) Failed to invoke a system function, read() or Failed to invoke the read() system function
ERR-71019(errno=104) Failed to invoke a system function, write()
ERR-91015 ( 593941) Communication failure
How to check the 8-digit errorcode of altibase_qp.log
Not found data
tablespace does not have enough free space error
AdminCenter2 execution file
An error occurs when uploading a DOS format data file to iloader.
Thread process debugging method
The entire database exists in memory. Is there any problem with the safety of the data?
What interface does Altibase provide?
What is the biggest difference between Altibase and disk-based DBMS?
Altibase Error Messages
make Cannot find a rule to create target connect1.o from dependencies.
ERR-0106B The session has been disconnected by the client
ERR-01044 Client's query exceeded in the execution time limitation
ERR-01050 License File does not exist
ERR-01067 The memory size allocated for the statement has exceeded the maximum limit
ERR-0108D License invalid or expired
ERR-0109D Insufficient memory
ERR-11030 The data file cannot be extended because the requested size is bigger than the maximum size (262144 pages)
ERR-11036 The data file is in use
ERR-11041 A deadlock situation has been detected
ERR-11049 Too many pages were allocated
ERR-1105D Unable to begin a new update statement
ERR-11058 The row already exists in a unique index
ERR-11075 The transaction has exceeded the lock timeout specified by the user
ERR-11118 The update log size '10485760' is bigger than TRX_UPDATE_MAX_LOGSIZE
ERR-11123 The tablespace does not have enough free space
ERR-11098 smERR_ABORT_BackupLogMode cannot be executed in no archive log mode
ERR-110AA Duplicate tablespace names
ERR-2100D Invalid length of the data type
ERR-21010 Value overflow
ERR-21011 Invalid literal
ERR-21013 Calculation stack overflow
ERR-31088 A replicated table must have a primary key
ERR-3109F REPL sender failure to handshake with peer server
ERR-311E0 The estimated size of the index key exceeds the maximum limit
ERR-31283 Unable to create a primary key or a unique key constraint in the local non-prefixed index
ERR-40029 Failed to invoke a system function, flock_trywrlock()
ERR-4102C Incompatible NLS between the client and the server
ERR-41047 The transaction is already active
ERR-41059 Task pool overflow
ERR-4109C invalid session property
ERR-410CF Too many statements have been allocated to this session
ERR-410D5 Client unable to establish connection.
ERR-7101d Protocol header error
ERR-51039 Invalid Protocol
ERR-51043 Communication link failure
ERR-6100D Sender failed to handshake with the peer server
ERR-61035 Receiver - An update conflict occurred
ERR-61100 rpERR_ABORT_RPC_DUPLICATE_REPLICATION Duplicate replication names. The replication name already exists in the database.
ERR-71018 Failed to invoke the read() system function
ERR-71019 Failed to invoke the write() system function Flush protocol failed. Close connection
ERR-91020 No Connection State
ERR-9103D Data parsing error - LineXXXX
ERR-201436 The number of host variables exceed the maximum limit (1024)
ERR-11025 The data file already exists
ERR-11027 The data file does not exist
ERR-11035 The tablespace does not have enough free space
ERR-11136 The LogAnchor file already exists
ERR-135181 Invalid data type length
ERR-266300 Request of fetching data to an unprepared SQL statement
ERR-31020 You cannot execute DDL on a replicated table
ERR-3103F No DDL statement is allowed to be executed on a replicated table
ERR-311B1 The user must have SYSDBA privilege(s) to execute this statement
ERR-312C4 Cannot execute this DDL on a replicated table when the system property REPLICATION_DDL_ENABLE is 0
ERR-1051 Memory allocation failed
ERR-0001c Unable to shutdown the communication channel
ERR-01002 Invalid character in use
ERR-01027 No more IPC channel
ERR-0109F Library file for external procedure(function) not found
ERR-11009 Failed to invoke a system function, shmat()
ERR-11107 smERR_ABORT_UNABLE_TO_CREATE_CUZ_VOL_MAX_DB_SIZE Unable to create the tablespace because the database would be larger than VOLATILE_MAX_DB_SIZE
ERR-11118 The update log size '…' is bigger than TRX_UPDATE_MAX_LOGSIZE '…'
ERR-31233 The fixed record size exceeds the page size
ERR-31240 Invalid request to process SQL statement
ERR-4105A Several statements still open
ERR-410B7 Invalid size of data to bind to a host variable Data Size
ERR-51024 Different protocol versions
ERR-5102E Invalid cursor state
ERR-51041 Indicator variable required but not supplied
ERR-5104F Communication link failure.
ERR-5105A The connection does not exist.
ERR-52027 String data right-truncated
ERR-61001 A conflict occurred while executing the received statement
ERR-61016 rpERR_ABORT_RP_SENDER_MAKE_XLOG Sender Failed to make an xlog
ERR-61023 rpERR_ABORT_RP_REPLICATION_DISABLED Replication is disabled
ERR-61036 Receiver err_not found in deleteXlog()
ERR-6103a Receiver err_not_found in updateXlog()
ERR-610CF The transaction table size of the replication does not match
ERR-610D2 The primary key column count of the replicated table does not match
ERR-610a0 Sender Stopping REP1 sender thread
ERR-61113 A replicated table must have a primary key.
ERR-71015 cmERR_ABORT_SELECT_ERROR Failed to invoke the select() system function
ERR-91013 The query was too long the maximum length is 65536
ERR-9102B utERR_ABORT_Token_Value_Range_Error Token value length overflow. Maximum token length=0%d. Column =1%s, Value=2%s
ERR-91044 Error occurred during data file IO.
ERR-A100C Conversion not applicable
ERR-A1013 Calculation stack overflow
ERR-0104E The property XXX is read-only
ERR-110F0 Unable to extend the tablespace (SYS_TBS_MEM_DIC) because the database would be larger than MEM_MAX_DB_SIZE(12582912K)
ERR-41041 Another SYSDBA session is already running
ERR-51014 Function sequence error
ERR-5104D Connection timeout
ERR-51067 Neither PORT_NO in the connection string or ALTIBASE_PORT_NO environment variable are set
ERR-51192 The call to getaddrinfo() failed. The host name or service may be unknown
ERR-61000 The received record was not found in the database
ERR-6100C rpERR_ABORT_RP_RECEIVER_NOT_FOUND The receiver does not exist
ERR-1102A Tablespace node not found
ALTIBASE HDB Administration
How to terminate a session
SQL about Objects
SQL about Replication
SQL about Sessions
SQL about Statements
SQL about Tablespaces
ALTIBASE HDB Architecture
ALTIBASE HDB Architecture Overview
How a query is executed in ALTIBASE HDB
Transaction Durability in ALTIBASE HDB
ALTIBASE HDB Developer
ALTIBASE HDB General Information
ALTIBASE HDB Performance Tuning
Performance diagnostics for ALTIBASE HDB
1. Application side diagnostics
2. Database side diagnostics
3. System side diagnostics
ALTIBASE HDB Replication
What is a Replication Conflict?
How to resolve a replication conflict?
What is Offline Replicator?
ALTIBASE HDB Troubleshooting
Information required to diagnose ALTIBASE HDB problems
A transaction exceeds lock timeout value specified by user
The number of logfiles grows rapidly
A user tablespace does not have enough free space
Cannot insert new records after deleting bulk records
1. Test case with ALTIBASE HDB 5.3.3
2. How did we determine that the cause of the problem is the Index Segment ?
3. How to avoid the problem by seperating Tablespaces ?
Performance degradation issue when upgrading AIX OS to 6.1