Other

Question: What are the effects of increasing the value of the pd_max_users operand in order to accommodate more users?

Answer: For details about the effects of increasing the value of the pd_max_users operand, see 9.5 Handling an increase in the number of users.

(2) No UAP is connected, but user identification information is displayed

Question: No UAP is connected, so why is user identification information displayed when the pdls -d act command is executed?

Answer: If transaction rollback was not completed after a server process was aborted or rerun, the user identification information is retained. This user identification information will be deleted once transaction rollback is completed.

(3) Can the system time be changed?

Question: I want to change the system time to do some tests. Is it possible to change the system time?; What would be the effects of forcibly advancing or rolling back the system date or time?

Answer

HiRDB stores date and time information in the system log files, status files, dictionaries, and work files of various utilities for use during operations such as HiRDB restart. Therefore, if you change the system time you must make sure that the date and time information held by HiRDB will not be affected. Special care must be exercised when moving the time back. For details about changing the time, see 9.12 Changing the time used by the OS.

When changing the time at an SNTP client, pay attention to the following issue in addition to the information given in 9.12 Changing the time used by the OS:

Synchronization with the primary server might involve a time change when necessary, and as a result the time might be changed without the user being aware of it.

(4) Authorization identifiers and passwords are not being recognized correctly

Question: Why are authorization identifiers and passwords not being recognized correctly?

Answer

It is possible that upper- and lower-case letters are not being recognized correctly. If lower-case letters are included, the character strings must be enclosed in quotation marks ("). Otherwise, the lower-case letters will be regarded as upper-case letters.

Example

SELECT * FROM "user05".TABLE05;

(5) The HiRDB directory has been inadvertently deleted

Question: I have inadvertently deleted the files under a HiRDB directory. How can I recover them?

Answer

You can use the pdsetup command to recover the deleted files. Take the following steps:

Procedure

Save the files that are under $PDDIR/spool (the contents of $PDDIR/spool will be initialized when the pdsetup command is executed).
Use the pdstop command to terminate HiRDB.
Execute the pdsetup -d command. Respond with Y to the message that appears.
Re-execute the pdsetup command. The files are copied to the HiRDB directory.

Appendix A.11 Other

(1) Increasing the number of executing users

(2) No UAP is connected, but user identification information is displayed

(3) Can the system time be changed?

(4) Authorization identifiers and passwords are not being recognized correctly

(5) The HiRDB directory has been inadvertently deleted