티스토리

pajama

검색하기

블로그 홈

pajama

ipajama.tistory.com/m

@ipajama 님의 블로그입니다.

구독자: 1

방명록 방문하기

주요 글 목록

How To Remove Shared Memory Segments QuestionRemove Shared Memory Segments AnswerDirections for removing shared memory segments are as follows: (must be root) Get your SERVERNUM from the onconfigConvert that to hex and add it to 5256 in hexipcs -m |grep 5256+SERVERNUM(in hex)The ID is the second column in the output. Write down each of the ID numbers.Take the list of IDs and run ipcrm -m ID for each ID. so an exam.. 공감수 0 댓글수 0 2014. 10. 22.
Is there an Alternative to hosts.equiv for High Availability Data Replication? QuestionHigh availability replication (HDR) requires a trust relationship for user informix between the machines in the HDR pair. Is there an alternative to using hosts.equiv for establishing the trust? Answer You can use the .netrc file to establish trust between computers. Locate the file in the informix user home directory on both machines. It should have a line like the fol.. 공감수 0 댓글수 0 2014. 5. 20.
Point-in-time recovery using archecker. QuestionSometime you may need to restore a single table from an archive. In fact you may want the table exactly as it was at a specific date and time, and we can do this using archecker. It is important to note that the format of the datetime you provide to archecker depends the values in environment variables such as DBTIME, GL_DATETIME, or CLIENT_LOCALE when the back up was t.. 공감수 0 댓글수 0 2014. 4. 18.
An ontape archive failing for lack of available memory QuestionWhat is the minimum amount of contiguous memory needed for ontape archive to work? CauseLack of available contiguous memory can cause ontape archive to fail with an assertion warning "ISAM error: An error has occurred during archive back up". AnswerWhen you start an ontape archive, the ontape (front-end) process will allocate four blocks of contiguous memory in the siz.. 공감수 0 댓글수 0 2014. 4. 14.
Connections to database server are not allowed when Informix started with user informix on AIX platform. Problem(Abstract)On AIX platform connection to the database server failing with invalid password message, when Informix strarted with user 'informix'. However, if you start it as user 'root', problem does not occur. Following is a different manifestation of the similar problem. With user 'informix' connecting to database server using 'dbaccess -> Query-language -> Select.. 공감수 0 댓글수 0 2014. 4. 11.
A possible solution for a -952 error when seen on AIX while a remote Kerberos/AD user account is authenticating to IDS Problem(Abstract)The -952 error is generally a bad account/password combination. However when there is 100% confidence that the account/password combination is correct, a -952 error can still occur. This article explains one scenario and a possible solution for that problem. SymptomAssumptions: 100% confidence that the account/password combination is correctThe OS is properly .. 공감수 0 댓글수 0 2014. 4. 11.
-951 / -952 when using Loadable Password Algorithm (LPA) ie. ssha1, ssha256, blowfish, smb5 on AIX Problem(Abstract)When configuring IDS to use LPA (ssha1, ssha256 ,sblowfish, smb5, etc) you get -951/-952 errors on AIX CauseThe underlaying problem is that the default settings on AIX for the LPA mapping config file are such that only root can read the file. Crypt() function in IDS is run on a CPU VP which is non-root and AIX requires it to be run as root if using LPA, a work.. 공감수 0 댓글수 0 2014. 4. 11.
-951 and -952 errors when connecting as user informix on AIX Problem(Abstract)After configuring LPA (Loadable Password Algorithm) on AIX, you see -951 and -952 errors when trying to connect as user informix. -and using PAM is not an immediate option CauseAIX has made the /etc/security/pwdalg.cfg file unreadable to normal users (users other than root), hence -attempting to authenticate as user informix does not work. Resolving the proble.. 공감수 0 댓글수 0 2014. 4. 11.
onbar backups on AIX incurring BAR_TIMEOUT warnings and XBSA errors Problem(Abstract)An onbar backup can run on XBSA errors, preceded by BAR_TIMEOUT warnings, due to a tcp/ip send problem in AIX. SymptomIn baract.log file you'd see XBSA errors like the following: XBSA Error: (BSACreateObject) A system error occurred. Aborting XBSA session. or XBSA Error: (BSAEndTxn) The transaction was aborted. Due to the nature of the underlying tcp problem - .. 공감수 0 댓글수 0 2014. 3. 28.
IBM Informix Server produces a warning message on AIX when Informix shared memory is pinned and KAIO or DIRECT_IO is enabled Problem(Abstract)IBM® Informix® Server™ version11.70.FC5W1 and higher will produce a warning message in the online.log and to STDERR, when you have RESIDENT enabled in the ONCONFIG file and either KAIO or DIRECT_IO enabled. This warning is only displayed for Informix when running on AIX® and is not displayed in earlier versions. SymptomAn example of the warnin.. 공감수 0 댓글수 0 2014. 3. 26.
Tuning Asynchronous-I/O Kernel parameters to avoid error KAIO out of resource on HP-UX Problem(Abstract)This article goes over the Operating System Kernel that can be configured to avoid error KAIO out of resource on the HP-UX platform Resolving the problem PROBLEM When using Kernel Asynchronous I/O (KAIO) with IBM Informix Dynamic Servers, you might experience the following message in the database server message log: KAIO out of resource errno=11orKAIO out of re.. 공감수 0 댓글수 0 2014. 3. 26.
Tuning Kernel Asynchronous I/O (KAIO) for IBM Informix on HP-UX Problem(Abstract)This article goes over the environment variable that can be used to change the default resources used by the engine for Kernel Asynchronous I/O (KAIO) on the HP-UX platform. Resolving the problem PROBLEM Database performance is poor because of input/output (I/O) requests. The IBM® Informix® Dynamic Server™ message log might display one of these erro.. 공감수 0 댓글수 0 2014. 3. 26.
Cannot start Informix with error size of resident + virtual segments Problem(Abstract)You try to start the Informix server but it fails to start with messages like these in the online.log: 21:45:30 IBM Informix Dynamic Server Started. 21:45:30 size of resident + virtual segments 10443875920 + 4831838208 > 9663676416 total allowed by configuration parameter SHMTOTAL Symptom output of oninit -v: Checking group membership to determine server ru.. 공감수 0 댓글수 0 2014. 3. 24.
Client sessions may become blocked for processing on Primary during data transmission issue between the Primary and the HDR Secondary Problem(Abstract)When there is a data transmission issue between Primary and HDR Secondary (usually caused by a network problem) the client applications which are working with the Primary may become blocked and may look hung even if the data replication is configured to be asynchronous (DRINTERVAL > 0). SymptomOnce the ping timeout is written to the online.log file of the P.. 공감수 0 댓글수 0 2014. 3. 24.
HDR ping timeout dive Problem(Abstract)Sometime you can get "ping timeout" and "send error" in online.log,and check network environment,which are all normal.Last HDR relation had been broken.Why do it occur ? Symptomping timeout,received error,send error Causeping timeout will occur if "DR_MSG_PING" can't flow between primary and secondary,or ack duration exceed 4*DRTIMEOUT."ping timeout" is a mess.. 공감수 0 댓글수 0 2014. 3. 24.
FAILED: Fetch statement failed: Encoding or code set not supported. error -79783 Problem(Abstract)After JDBC upgrade to 3.50.JC1 onwards, customer who are using Multibyte codeset might received error such as : "FAILED: Fetch statement failed: Encoding or code set not supported. " error -79783 SymptomError message: "FAILED: Fetch statement failed: Encoding or code set not supported. " error -79783 CauseJDBC version 3.50.JC1 introduced the following APAR: IC.. 공감수 0 댓글수 0 2014. 3. 7.
Identifying Locks from Updatable Secondary Servers Problem(Abstract)Prior to Informix Cluster environments, locks were ignored on an HDR secondary. With updateable secondary servers in 11.50.xC8 and above, the lock request is sent to the Primary. This document will help you identify and track these locks from a primary server back to the secondary server it came from. SymptomLock requests showing up on a primary server that do.. 공감수 0 댓글수 0 2014. 2. 24.
Java program getting "OutOfMemory" when handling blobs. Problem(Abstract)A java program getting "OutOfMemory" when handling blobs. Informix JDBC Driver uses the java File.deleteOnExit when handling blobs which causes the OutOfMemory problem in the JVM heap. Resolving the problem PROBLEM A java application that uses Informix JDBC Driver to deal with BLOBs runs out of memory. Informix JDBC Driver uses the java File.deleteOnExit which .. 공감수 0 댓글수 0 2014. 2. 21.
Data corruption issue during migration from older server Problem(Abstract) When migrating from an older server that supports only the ISO-8859-1 locale to a newer server that uses UTF-8 locale to configure a database, the new database might not accept all characters without first using a conversion process. Symptom When attempting to load data from a database created with ISO-8859-1 locale into a database using UTF-8 locale, reject .. 공감수 0 댓글수 0 2014. 1. 11.
A long running session may allocate huge memory pool if DONTDRAINPOOLS environment variable was enabled on server's startup Problem(Abstract)A long running session may allocate huge memory pool if DONTDRAINPOOLS environment variable was enabled on server's startup SymptomYou notice that long running sessions have large memory pools allocated (can be up to several gigabytes). onstat -g ses session #RSAM total used dynamic id user tty pid hostname threads memory memory explain <...> 229697969 u.. 공감수 0 댓글수 0 2013. 12. 22.
How to get a Null value instead of a backslash(\) when unloading an empty varchar string. Problem(Abstract)This article tells you how to get a Null value(||) instead of a backslash (|\|) When you unload an empty varchar string. SymptomWhen executing SQL like below: Example: unload to x.unl select tabname, "" from systables where tabname = "tab1" The output file contains: tab1|\ | CauseIt is expected behavior as NULL cannot be represented by "", because IBM Informix .. 공감수 0 댓글수 0 2013. 12. 6.
Informix Server on Oracle Solaris 11 may fail to start Problem(Abstract) After installing the "Critical Patch Update October 2013 for Solaris 11" (ORACLE SOLARIS 11.1.12.5.0 REPO ISO IMAGE) on your Oracle Solaris 11 system your Informix Server instance may fail to start Symptom During the Informix instance start you will see following types of error messages in the instance message log and the instance will not come online: 13:23:.. 공감수 0 댓글수 0 2013. 11. 12.
How to unload rows from a table avoiding inaccessible data using the ROWID Problem(Abstract) How to unload rows from a table avoiding inaccessible data using the ROWID on data corruption scenarios. Resolving the problem INTRODUCTION This document describes a technique that can help you rebuild a table based on the data that might be still accessible. It uses the concept of the ROWIDs and the UNLOAD command. Attention: This technique only saves rows t.. 공감수 0 댓글수 0 2013. 11. 11.
Needed to send a ping message but failed. 1 Problem(Abstract) Randomly the following error shows up in the mesage.log of the Primary server of a HDR pair: Needed to send a ping message but failed. 1 SymptomMessages similar to the following will be displayed in the Message.log on Primary HDR server. R: Needed to send a ping message but failed. 1 12:31:25 Logical Log 358 Complete, timestamp: 0x20c592c5. 12:31:27 DR: Neede.. 공감수 0 댓글수 0 2013. 9. 30.
Archive failed - access sysmaster database (SQL:-404 ISAM:0) Problem(Abstract)Running ontape L 0 archive can fail with the following error Archive failed - access sysmaster database (SQL:-404 ISAM:0) CauseCertain env variables set Resolving the problemdetermine if any of the following environment variables are set and unset them IFX_AUTOFREEIFX_DEFERRED_PREPAREOPTOFC http://www-01.ibm.com/support/docview.wss?uid=swg21648070&myns=swgimgmt.. 공감수 0 댓글수 0 2013. 9. 6.
KAIO is not enabled when chunks are created on raw devices in Unix systems Problem(Abstract) KAIO is not enabled when chunks are created on raw devices. OS and related environment are no problems. Causels -l shows that the chunks are in the raw devices which are created as block devices by mistake. ls -l brw-rw---- 1 root system 22, 1 Aug 4 2012 rootchk brw-rw---- 1 root system 22, 1 Aug 4 2012 llogchk brw-rw---- 1 root system 22, 1 Aug 4 2012 plogch.. 공감수 0 댓글수 0 2013. 8. 20.
Finding the slowest SQL queries on IBM INFORMIX instance Problem(Abstract)The following query is to identify the 10 slowest SQL queries from syssqltrace. Note : SQLTRACE in $ONCONFIG need to be enabled in order to trace the SQL Queries. Resolving the problemTo find the SQL Queries: SELECT FIRST 10 * FROM sysmaster:syssqltrace WHERE sql_runtime > 0 ORDER BY sql_runtime DESC; Then you can use the sql_id to query the sqltrace_iter t.. 공감수 0 댓글수 0 2013. 7. 10.
dbimport 중 Import data is corrupted! 메시지 발생 데이터 정합성이 맞지않거나 통계정보 부정확등의 이유에 인해 dbexport로 추출된 데이터 건수가 실제 내려받은 데이터 건수와 다른 경우에 발생하는 오류 케이스입니다. It might happen that the number of rows in the unload file does not match the number of rows in the comment. In such cases the dbimport will fail. dbimport.. 공감수 0 댓글수 0 2013. 6. 5.
Query with COUNT(*) fails with errors -252/-113 Problem(Abstract) When running a select query that contains COUNT(*) the following errors are returned: > echo "select count(*) from customer;" | dbaccess stores_demo Database selected. 252: Cannot get system information for table. 113: ISAM error: the file is locked. Error in line 1 Near character position 61 Database closed. Symptom Errors -252/-113 are returned: 252: Can.. 공감수 0 댓글수 0 2013. 6. 2.
Increase performance by removing sequential scans Question How to increase performance by monitoring when the optimizer chooses to sequential scan a table instead of another alternative access method and then changing the table so that the optimizer selects the optimal method. Answer INTRODUCTION In some circumstances small mistake in managing an IBM® Informix® Dynamic Server™ (IDS) can generate significant perfor.. 공감수 0 댓글수 0 2013. 5. 20.

문의안내

티스토리
로그인
고객센터

티스토리는 카카오에서 사랑을 담아 만듭니다.