I
- Is there a way to show/not show 'implicitly hidden columns' that were created in an SQL Table in DBU?
When an SQL table contains ‘implicitly hidden columns’, SQL will not show those columns when * is used in the SELECT statement to view the data. If ... - I would like to know the proper way to end/start the DBURDBSBS subsystem, since we are automate our backup, or they start automatically when the TCPSVR starts?? so I can add the command in our backup CL???
You can use the following command to end the DBURDBSBS subsystem: ENDSBS SBS(DBURDBSBS) OPTION(*IMMED) You can use the following command to start the DBURDBSBS subsystem: STRSBS SBSD(DBU10/DBURDBSBS) The subsystem ... - I have DBU installed on my system. Is it safe to delete DBUINSTALL library?
Yes, you can delete the DBUINSTALL library. ... - I have the current DBU library in my library list, but the previous DBU always comes up when I key in the DBU command. What do I need to do?<br />
You must have the DBU command somewhere other than the current DBU library. Determine where DBU command is, WRKOBJ *LIBL/DBU *CMD. Either delete the command from ... - Is there a limit to the number of key fields for DBU F6 (Set Key)?
Yes, DBU F6 (Set Key) can handle, up to and including, 32 key fields in any file. ... - I attempted to install DBU RDB without *IOSYSCFG authority, do I need to reinstall it with *IOSYSCFG authority?
Yes, once you have a profile that has *IOSYSCFG authority just reinstall DBU and DBU RDB software. ... - Is there any auditing available with the use of DBU/RDB?
Changes made with DBU/RDB can be tracked with the DBU Audit plug-in. ... - I downloaded the file and ran the install but received an FtpCommand failed error message near the end of the install<br />
When installing you need to make sure the FTP server is running on your server. If it is, you may need to contact your network ... - Is there any way to track the usage by User, Date, Time, and System Name each time DBU is accessed?
Yes. Follow the steps below to track DBU usage. CRTJRNRCV JRNRCV(USERLIB/DBUUSE0001) CRTJRN JRN(USERLIB/DBUUSEJRN) JRNRCV(USERLIB/DBUUSE0001) STRJRNOBJ OBJ(DBU10/DBUSTS) OBJTYPE(*DTAARA) JRN(USERLIB/DBUUSEJRN) IMAGES(*BOTH) Execute DBU on any file. DSPJRN JRN(USERLIB/DBUUSEJRN) OBJ((DBU10/DBUSTS *DTAARA *FIRST)) ENTTYP(EB) ... - I attempted to install DBU RDB without *IOSYSCFG authority, do I need to reinstall it with *IOSYSCFG authority?
Yes, once you have a profile that has *IOSYSCFG authority just reinstall DBU and DBU RDB software. ... - Is there any auditing available with the use of DBU/RDB?
Changes made with DBU/RDB can be tracked with the DBU Audit plug-in. ... - Is there any auditing available with the use of DBU/RDB?
Changes made with DBU/RDB can be tracked with the DBU Audit plug-in. ... - Is DBU and all products compatible with the current operating system?
Check it out here: https://dodbu.com/documentation/compatibility.pdf ... - Is there a limitation of statement length when embedding SQL/PRO into CL?
Yes, SQL statement length must be less than 5000 characters due to IBM limitations. ...