Asset Suite / PassPort Tools
| Forum | Topics | Posts | Last post |
|---|
Analyst WorkBench topics.
| 4 | 12 | by webmaster |
Systems Administration Guide for PassPort ver 10, around page 2-107 describes tigaudit. Tigaudit writes before and after data into table TIDAUDIT on a panel level or at the I/O subroutine level, example: tigcnmst.csm for tracking Contract status changes.
Systems Administration panel X085 turns on and off the panel auditing. Adding a line of code to the I/O subroutine turns on I/O auditing via the panel's .ccp program accessing the I/O subroutine via tigcurs, for example, whatever subroutine is accessed in paragraph A000- or one of the other A###- paragraphs of the .ccp.
The TIDAUDIT table is similar to the OLE TIDBLOB table in that the before and after data is stored as hexidecimal. Make things a bit easier by redefining table TIDAUDIT so that column Audit_Data is of data type BLOB instead of LONG RAW. Oracle version 9 provides built in BLOB functionality. For example the below SQL can be used to look at entries. Note that UTL_RAW was introduced with Oracle 9. Be aware that this will return hexadecimal values and it's highly likely to screw up a GUI SQL tool like DBArtisan. If you're Oracle on Unix, run sqlplus in a shell and redirect standard output to a file.
select cursor_manager
,function_code
,passport
,panel_id_7
,time_stamp
,UTL_RAW.CAST_TO_VARCHAR2(audit_data)
from passport.tidaudit
where cursor_manager= 'TIGCNMST'
and function_code = 'UPDATE-B'
and time_stamp = '2006-01-09-17.03.31.456008'
;
| 0 | 0 | n/a |
See forum MicroFocus COBOL, topic MicroFocus COBOL compiling with listing for changing dfcn to output compilation listing.
What copy libraries (Unix directories) are used for compiling via dfcn is determined by the PassPort region's dfconfig file's "INC_DIR= " entry. INC_DIR should be defined as a chain of directories starting with the development region's gencopy directory, then the copy directory, then the test region's gencopy directory, then the copy directory and so on through the baseline directories.
| 0 | 0 | n/a |
Create a file (dd.sql) with the following SQL. Works for Oracle and DB2.
| 1 | 1 | by webmaster |
Handy when database refreshes wipe out the test or development PassPort IDs.
insert into tidppopt values ('PPID8chr','999','A',' ',' ','99990',' ','LASTNAME','FIRSTNAME','I','LOCAL',' ',' ','Y',' ',' ','Y',' ','Y','Y','A',' ',' ',' ',' ',' ',' ','F',' ',current timestamp,'2006-01-30-00.00.00.000000')
;
insert into tidprefs values ('PWD-EXPIRE-DATE','U','PPID8chr',' ','20301231','PPID8chr','20060130','2006-01-30-00.00.00.000000')
;
Password expiration is set to 2030-12-31.
| 0 | 0 | n/a |
How to use dftbunld and dftbld to move Oracle data between Oracle instances.
| 1 | 1 | by webmaster |
Here's a crude Java program to read LONG and LONG RAW data out of Asset Suite / PassPort database tables.
| 1 | 1 | by webmaster |
|