I
Is it possible to set the timeout in any JDBC setting?
Yes, you can use the following codes to achieve your purpose:
Class.forName("dbmaker.sql.JdbcOdbcDriver");
Connection con = DriverManager.getConnection(
"jdbc:dbmaker://127.0.0.1:2453/dbsample4;CTIMO=30;","sysadm",""); ...
If the db shutdown abnormally, does DBMaker do instance recovery?
If DB is abnormal shutdown, maybe the page buffer data will not write into data file. After the DB started,the DBMaker server will do a ...
If there are several journal files and switch current journal file to next one, does the checkpoint occur?
Yes, when writing journal buffer into journal file (check point) and find the journal file does not have enough space, server will write the journal ...
In Oracle, user can write the following statement to implement the conversion from date type to char type, how can I do that in DBMaker?
select * from QMDVFCMDBS where
sts_tkystr = to_char(sysdate,'yyyymmdd')
There also have conversion functions todate and datetostr in DBMaker which located in \DBMaker\x.x\shared\udf. It need user to create UDF first.
Alternatively, you can implement it ...
If I want to reduce disk I/O,what should be done with DBMaker? (From DBMR1742)
DBMaker 4.3 supports two internal configuration keywords (DB_DSYNC, and DB_JSYCN), they can turn off DBMaker flush function and let the OS to control IO. But ...
Is it possible to control the ON/OFF of ODBC log by SQL? (From DBMR 1805)
At present, user can only control the ON/OFF of ODBC log by setting dmconfig.ini and restarting DB. Restarting DB makes keyword settings efficacious. ...
If wants to change the character set, should it need to reinstall DBMaker and recreate DB? And is there encoding method like NLS_LANG of Oracle, so that user can not have to recreate DB? (From DBMR 1805)
If wants to change the character set, user only needs to recreate DB with new DB_LCODE.
NLS_LANGE in Oracle is a parameter which effects client side ...
In DBMaker 4.0, where is the Audit log file output to? Please tell me both cases: 1.start db by service.
2. Start db by dmserver and in which version can set AUDIT LOG directory?
Audit log file will be located in one of the following directories:
1. OS system directory (such as C:\WINNT\system32).
2. DBMaker home directory\bin directory or working directory.
3. ...
If the customer set specific time for PITR like 02/10 10:00:00, dbmaker can recover the database to the exact time? (DBMR1968; Version: DBMaker 4.3.4 bundle)
Yes, DBMaker can restore the database to the exact time (DB_RTime).
When doing recover with setting DB_RTime, dbmaker will compare time of journal records in each ...
is there some Notices for upgrade DBMaker 4.3 to 5.1 in application side?(DBMR1975; version:DBMaker 4.3)
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 application ...
Is DCI compatible with Acucobol v10? (DBMR2939)
DBMaker 5.4.2 or later version supports ACUCOBOL-GT 10. User can link dmacu90 library in Linux. Please refer the setup steps from DCI_README.TXT.
Notice: Please do NOT ...
Is possible create the view materialized in DBMaker? (DBMR3096)
Materialized view is the physical copy of the original base tables. Unlike view, the materialized view is precomputed and stored on a disk, and they ...