W

• Why does DBMaker not use NAS
  The reasons that DBMaker does not use NAS are: 1.Simply, we cannot warrant and support this way. 2.Network makes performance worse. 3.Network failure can cause data ...
• Why does some query become slower after some days, and updating statistics does not speed them up. The only way to have these queries fast as before is to download tables, drop tables and re-load tables. Why does this problem occur?(From 1851, version: DBMaker4.3)
  This may be a special case about optimizer; DBMaker optimizer supposes the data distribution is Uniform in table. The optimizer can not find out merge ...
• Which Linux platform does DBMaster 5.0 support
  After 5.0, DBMaster will change release issue for Linux platform from Glibc2.1 upgrade to Glibc2.3. Please pay attention: 1. Glibc2.1 Linux environment can not run in Glibc2.3 ...
• What cause the DB file and SDB corruption? (From DBMR 1854)
  When this happens, it should not be DB engine's problem. In most case, DB file damage is caused by hardware and environments, for example: thunderbolt, ...
• Why is the .msg file empty when use the Stored Procedure and occur the compile error
  Generally speaking, if the .msg file is empty, it means user does not have a C compiler installed. Please install C compiler, such as VC6 ...
• What should I do when I insert a record and find that the journal file is full?
  There is only 1 journal file whose size is 4MB that DBMaker defaulted, so the only way to solve this problem is to increase the size ...
• Would you please give me some notes for DB design?
  System Structure: This requirement is configured almost same as others. You need to consider: (1) Using 3-tier or Server/Client to reduce the loading of Database Server, (2) Using ...
• Why does ESQL/C make error when links to the EC program after compiled successfully in UNIX?
  Because for Redhat9 or later versions, the libdmapic.a that is used to link the EC program needs to be recompiled under Redhat9. And we have built ...
• Why do the error messages turn into garbage characters in Windows?
  When users link their ODBC program, we suggest that the users link to the dmapi4X.lib. Otherwise, users maybe face the garbage characters error if the ...
• When and how does DBMaker use user order file (EBCDIC_stroke.ord)?
  To use the user defined Order, user should put the order file they defined into $DBMaker_Home/shared/codeorder. And then, use the DB_Order keywords to specify the ...
• What should the program do when calling the ODBC functions and the returned SQL code is SQL_ERROR or SQL_SUSSESS_WITH_INFO? Does it need error handling?
  Yes, the program should do error handling. First, customer can use the SQLERROR() to      get the details about the error massage, Then use different ...
• What is the function of the FillFACTOR parameter when create table?
  The FILLFACTOR feature optimizes the utilization of space for data pages byreserving space for the expansion of existing records. When a record grows up and ...
• When load the file which was unloaded from other DB (not DBMaker) in SQL script into DBMaker, what should be paid attention?
  To load the file into DBMaker successfully, you should care the following points: 1. To set the extname of the file to .s0. 2. Make sure the ...
• When does the DBMaker create .s1 file while unloading file from a DB?
  At present, The file size from DBMaker unloaded is about 1G,that’s limitation of DBMaker in dmSQL tool; So when DBMaker detects the exported file size ...
• What is the limitation to the number of the command handles when using JDBC data source to connect to DBMaker?
  At present (DBMaster 4.16/4.20), DBMaker allows the maximum of the command handles is 257.  But after 4.21, 4.22, 4.3 and later version, customer can set ...
• When execute an update command that the new data is large than the previous data, how does the DBMaker do?
  If the rest page space can contain new data, DBMaker will delete old data first then put new data in the same page position, if ...
• What value will be returned if one of the string expressions contains a NULL value in the CONCAT function?
  What value will be returned depends a setting which syntax is      SET CONCAT NULL RETURN { NULL | STRING } This option is used for string ...
• What is the encryption method of UID/Password in DBMaker？(From DBMR1717)
  The encryption technique used by DBMaker is a mix of DES and RSA. ...
• What ADO functions does DBMaker support? (From DBMR1726)
  There are three layers in ADO model, according to each model, the situation of the DBMaker supports are: 1. DBMaker supports Microsoft Activex Data Objects Library, ...
• Why it can connect to DBMaker 4.1 but cannot connect to 4.2/4.3 with the same connection string? (From DBMR1734)
  It is because that the check rules which DBMaker used to check connection string between 4.1 and 4.2/4.3 are different. For 4.1, DBMaker used simple check ...
• What the correct connection string should be? (From DBMR1734)
  For connection database, DBMaker supports two methods: Register DSN and do not Register DSN. If you have registered DSN, The correct connection string that can connect ...
• When I try to connect to the DB server with the dmSQL tool, why it returned the below error and failed? (From DBMR1741) ERROR (1119): [DBMaker] OS shared memory setting is too small, please increase OS shared memory maximum size. [dbstart. 816],0,0,0
  It is not the memory‘s business, Please set keyword DB_SVADR for this database. For example:   DB_SVADR=192.168.0.170; That will be ok.   ...
• Why dmserver failed to run on the machine that installed antivirus software? (From DBMR1737 & 1754)
  It may be the antivirus software’s business. Some antivirus software, such as NOD32, can prevent DBMaker accessing db files, then cause the dmserver fail to ...
• Why the previous DBMaker version can not start the DB after the DB was started by higher DBMaker version? Then how to salve? (From DBMR1747)
  Once you started the DB with the higher version, some file version or sys tables were modified, and the higher database can not be downgrade ...
• Why the memory occupation reduced when minimized the dmserver window in Windows Platform? (From 1748)
  It should be windows’ behavior. Not only the dmserver can show the phenomenon, other applications such as Outlook or IE can also show the phenomenon. ...
• What are the general steps about installing DBMaker Client and DSN on Windows platform manually? (From DBMR1783; Version: DBMaker 4.16)
  Generally, there are 4 steps to install DBMaker client and DSN; they are as following (take DBMaker 4.16 for example) Step1: Copy Files，insure the following files ...
• What are the general steps about installing DBMaker Driver and DSN on Windows platform manually? (From DBMR1783; Version: DBMaker 4.16)
  Generally, there are 4 steps to install DBMaker Driver and DSN; they are as following (take DBMaker 4.16 for example) Step1：Copy Files, insure the following files ...
• What is the process that ASP accesses DBMaker? (From DBMR1797 ;)
  The process that ASP accesses DBMaker is as following (Connection string = “DSN=ISDB;UID=SYSADM;PWD=”):  IIS -> ADO -> MSDASQL ->MS ODBC Driver Manager -> DBMaker Driver -> ...
• What is the detailed information about the dmconfig.ini keyword DCI_UDCUR?
  The DCI_UDCUR keyword has been removed from DBMaker since 4.2 series (after 01/06/2006). In early version, the keyword was used to increase speed in the ...
• We can choose the character set when installing DBMaker, does it means we also choose the message file character set? (From DBMR 1805)
  There are two steps to choose language and character set during installing DBMaker. The character set only decides data stored format, and is not related with ...
• What the possible reasons that can cause the Client disconnect?
  The possible reasons may be: 1. Idle time out. 2. Server restarts. 3. Network issue. 4. Bug; if it is bug, the error should be reproduced each time. 5. Socket ...
• Why does the error 8349 occur? But the length of the data does not over the 1024 byte, although the index including a Varchar (2000) type column? And how to avoid this occur? (From DBMR1811)
  (1). First, when creating an index which including varchar type column, DBMaker does not check the length of this index. For example: dmSQL> create table dbmr1811(id  SERIAL(1),application_name  ...
• What is the meaning of Low Value and High Value for column statistics? (From DBMR1813)
  You can see column statistics in JDBA Tool. For example: dmSQL> create table test(a serial); dmSQL> insert into test values(); 1 rows inserted dmSQL> insert into test values(); 1 rows inserted dmSQL> ...
• Why the JTools can not be started up in DBMaker Client side? (From DBMR1842; Version: DBMaker 4.1.2)
  There may be two reasons, and the most possible cause is privileges control. Maybe the Antivirus soft prevents access. Please check all Antivirus soft to confirm. The ...
• While there are two Unicode records in a table, one is the Simplified Chinese and one is Japanese. Why it returns all but not the correct one record which according to the search condition when executing a search? (Version: 4.2)
  When setting the DB_LCODE to value of 1 in DBMaker 4.2 version, the SIGNATURE TEXT INDEX will return all, but the IVF TEXT INDEX will ...
• Why does DBMaker duplicate the journal file without having an incremental backup? (DBMR 1875)
  This is a normal action which can avoid journal full problem. Although withouthaving an incremental backup, Backup Server (setting DB_BkSvr = 1) willcontinue to perform ...
• Will online full backup impact the online transaction? (DBMR: 1892, version: DBMaker 4.1 bundle)
  The main cost of the online full backup is IO, after checking database status and internal setting, database server will launch coping operation to start ...
• What is the recommended interval value for both online full backup and database replication? (DBMR: 1892, version: DBMaker 4.1 bundle)
  When setting Backup Schedule, user needs to consider how to set can make data lost less and can recovery when any types of database failure ...
• Why the code of character data is different from the original character data after being Exported and Imported by the XMLExport and XMLImport? (DBMR 1917; version: DBMaker 4.X)
  For DBMaker Japanese, the encoding of the XML file is Shift_JIS. Shift_JIS encoding has 2 types: 83pv and 90pv. If the original data is 83pv ...
• What is the relationship between the Keywords DB_ISOLV and DB_BROWS?
  The influence strength of DBMaker lock option is: SQL command >connect option >dmconfig.ini setting. If DB_ISOLV! = 2, 3, 4, DB_BROWS = 1 can work, if ...
• When running DBMaker perl sample program ("demo.pl") on DBMaker 5.0, what should be noticed by user?
   Suppose that version of DBD::DBMaker is 0.15:   1. Notice version of DBMaker: the original Makefile.PL may contain the entry at line12: my $DEFAULTVER = '3.7'; Modify the entry ...
• Why does the client side which is on Vista fail to connect to the server side that is on Windows XP sp2? (DBMR 1885; version: DBMaker 5.0)
  ...
• Why does the error “option type out of range” return When importing data into Excel 2003 from DBMaker4.3.0? (DBMR 1930; version: DBMaker4.3.0)
  It is a bug; we had fixed it after DBMaker 4.3.0. And we tested 4.3.1, 4.3.2 and 4.3.3, they were all ok. User can try ...
• What is the file databasename.pid used for? (DBMR1955; version: DBMaker4.3)
  File DBName.pid keeps dmserver running process id. It's for using ‘dmserver –k’ to shutdown database, we need to know which process id is catched by dmserver, ...
• What's the difference between error 11206, 11210 and 11213? (DBMR1957; version：DBMaker 4.3)
  User can distinguish them by their letter. Error 11213: cannot find file or directory in related directory. Error 11210: cannot have permission to access this file Error 11206: ...
• What is md5.dll, and how use MD5 related functions?
  md5.dll is the dll file of UDF in sample. Users also can create the dll by themselves. For detailed, please refer to README.TXT in ‘DBMaker InstallDir\samples\udf’ ...
• What does the ITT stand for and what's the correct range of values for it?
   ITT -- Internal Temporary Table: for sorting/ordering table in table join, select ... order by, etc. ITT uses physical memory, not use the DCCA. DBMaker has ...
• What is the influence of group commit when DBMaker install on a high-end machine specification? (DBMR: 1922 DBMaker 4.2 OS: CentOS 4.0)
  When we set DB_GCXMW = 0 in dmconfig.ini will turn off group commit feature and don't let db server let connection sleep. When db server ...
• When DBMaker will use ITT?
  ITT Internal Temporary Table is DBMaker internal database object that it’s used in memory table, query sort (like - group by, order by, merge join).its ...
• What should we Notice for upgrade dbmaker 4.3 to 5.1 in applications side (DBMR: 1975)
  Notice in application side: ODBC Driver: if application refers to Driver name (such as “Driver= {DBMaker 4.3 Driver}…”), user should modify it to 5.1 driver. DSN: if ...
• What about JDBC connection support parameters?
  JDBC connect string not only include connect information but also support some database keyword settings. In DBMaker connect string keyword support UID, PWD, SVADR, PTNUM, ...
• What about the null convert functions in DBMaster(DBMR2355)?
  Following are NULL convert function in DBMaster, please reference.   1. IFNULL is an ODBC function. IFNULL (v1, v2) is the equivalent to coalesce(v1,v2) and it’s equivalent ...
• What’s the function of dmBackup.l_k in DBMaker? (DBMR2268)
  dmBackup.l_k is used to lock dmBackup.his. When a backup is performed, DBMaker will automatically create dmBackup.l_k to ensure every process’s write operation on dmBackup.his is ...
• Which date format is supported by DBMaker? (DBMR2485)
  DBMaker supports following date format: Ÿ  Input Format: mm/dd/yy, mm-dd-yy, dd/mon/yy, dd-mon-yy, mm/dd/yyyy, mm-dd-yyyy, yyyy/mm/dd, yyyy-mm-dd, dd/mon/yyyy, dd-mon-yyyy, dd.mm.yyyy. Ÿ  Output Format: mm/dd/yy, mm-dd-yy, dd/mon/yy, dd-mon-yy, mm/dd/yyyy, ...
• What’s the path of the file DMDUMPxxxx_x.DMP? (DBMR2508)
  DMDUMPxxxx_x.DMP is usually located under the database directory which will be recorded into DMERROR.LOG. However, if a user uses the database of which version is ...
• Which situations will cause “nested join” faster than “merge join”? (DBMR2559)
  By default, if a table contains a small quantity of data, DBMaker will use “nested join” to query data. It scans part of data and ...
• What’s the difference of “SET UNLOAD CHARTOHEX value” in different versions of DBMaker? (DBMR2567)
  Ÿ   In DBMaker 4.1 The function of converting characters to HEX is not supported in DBMaker4.1, so all of the unloaded characters including unprintable characters can't ...
• What reasons may cause “ERROR – unable to allocate an environment handle”? (DBMR2537)
  This issue may be caused by the following two reasons. Ÿ   Out of memory(this error may still cause IIS crashes). Ÿ   The connection pool remains valid after ...
• Why return “sun.jdbc.odbc.JdbcOdbcDriver” message by Jtools? (DBMR2596)
  Those errors are mostly caused by a mismatch between DBMaker version and JRE version. Users can handle those errors by upgrading DBMaker or JRE.   Version: DBMaker ...
• Why cannot install 64bit DBMaker setup on some x64 platform? (DBMR2629)
  The cause of installing failure is that ‘Microsoft Visual C++ 2005 Redistributable Package’ is incompatible with DBMaker, and users can uninstall the original ‘Microsoft Visual ...
• Why DBMaker performance degraded after upgrading from 5.0.x to 5.2.x?
  After upgrading from 5.0.x to 5.2.x without using unload/load method, only starting same DB files with the higher version modules, due to the system catalog’s ...
• What's the meaning of "10054" and "[last func=32]" in the error message "ERROR (25350), connection already broken, database may already be shutdown or network may have failed [netio.c , 462],-1,0.10054 [last func=32]"? (DBMR2748)
   "[last = func 32]" is an internal definition and used for the developer to trace a position. "10054" means a socket error which may be caused ...
• What's the cause of ERROR(2405)? (DBMR2683)
  ERROR(2405) is a license option error. If use an evaluation version not activated by any license numbers, users should consider the following limitations on the ...
• Why the error "dmserver.bin: /lib64/libc.so.6: version GLIBC_2.7' not found (required by /home/dbmaker/5.4/lib/so/libxml2.so.2)” occurs when a user starts a database on Linux? (DBMR2769)
  On 32 bit Linux platform, the version of libxml2.so used by DBMaker is libxml2.so.2.6.27, therefore GLIBC's version requirement still is 2.3. On 64 bit Linux platform, ...
• Why the error "invalid top directory at /usr/lib/perl5/5.8.8/File/Find.pm line 592” happens when "perl Makefile.PL" is executed? (DBMR2689)
  Because the source code of DBD is too old and DBD only supports DBMaker 5.1 and previous versions, so a user can install DBMaker 5.1 ...
• When use new feature -- “set unload fileobj name”?
  “set unload fileobj name” was supported for keeping the FILE OBJECT not re-order during load to new DB. About SYSTEM FILE OBJECT, default setting is [set ...
• Why journal full occurs and how to deal with it?
  (1) Journal files size are too small Journal size default value is 4M, if it's caused by journal size too small, you can increase the journal ...
• Why Update Statistics not work for rebuilding index sometime?
  There are some reasons which can cause “update statistics” won’t be executed, for example: after migrate DB from 5.1 to 5.3, then execute update statistics ...
• Why lock-timeout happen while querying system tables? (DBMR2870)
   If you executed SQL statements in some simultaneous connections, for example: delete all records of one table, or drop/create table with "OUTPUT" in DCI, and ...
• Why can find the errors with "check db" easily in slave DB? (DBMR2922)
  If you executed "check db" command in slave side, the slave database read dirty data. It caused the data between master and slave database inconsistency. ...
• Why load external DB returned Segmentation fault at powerpc?
  The unixODBC installing package for powerpc didn't include libodbc.so. You need to create the symbolic link manually. Enter below commands:   $ cd /usr/lib/powerpc64le-linux-gnu $ ln -s libodbc.so.1.0.0 ...
• What connection string does DBMaker support to connect ODBC? (DBMR3000)
  DBMaker support below connection strings: DRIVER: ODBC driver version. DATABASE: Database name. DSN: Data source name. UID: User ID. PWD: Password. ERRLCODE: Set client's error message character set. CLILCODE: Set the language ...
• What is the fastest way to compare two tables? (DBMR3010)
  The “EXCEPT” operator is used to combine two “SELECT” statements and returns rows from the first SELECT statement that are not returned by the second ...
• When is it needed to set DB_UPGDB = 0? (DBMR3111)
  If you created database replication before DBMaker 5.4.3, and the version of master and slave database was different, it might cause some incompatibilities issue. We ...
• Why doesn’t NT Service write on network drive? (DBMR3177)
  If you get ERROR(11213): File or directory does not exist or ERROR(11206): Cannotcreate/open a file, this issue caused by restriction of Windows NT service. It'shard ...
• What is minimum length of column to save AES_ENCRYPT data?
  After using AES_ENCRYPT function, the data is encrypted and enlarged. If the length of column was not enough to save data, the system got ERROR ...
• Why does DBMaker return null when using QueryRunner or ResultSet function in JDBC?
  It’s a problem of org.apache.commons.dbutils.QueryRunner. If you have the same column name in different table, you have to use “as” syntax to set alias. For ...
• Why not return OPTION_VALUE value but be asked to input value when call getsystemoption('xxxxx',?) ?
  When new client connects to old server. Call getsystemoption('xxxxx',?) get weird result. It should return OPTION_VALUE value but be asked input value. It was caused ...
• Where does the driver stores informations when creating DSN?
  We got the Question you added in FAQ system. In fact, you can ask any question by sending mail to support_rd@syscom.com.tw And the FAQ system ...