New Ranks & Badges For The Community!
Notice something different? The ranks and associated badges have gone "Star Fleet". See what they all mean HERE
Highlighted
Absent Member.
Absent Member.
696 views

customizing connector.js?


Hello,

I try to change the DB-Connector for our DB2 connector and need to
change some timings in connector.js.
I added a copy from the SDK_2014 to the connector source directory.
But after compiling the compiler replaces the file from the common-SDK
directory. Adding it into files.include does not work.
What is the best way to include some changed files from the common-dir
of the SDK into the conenctor zip-file?

Torsten


--
tfechner
------------------------------------------------------------------------
tfechner's Profile: https://forums.netiq.com/member.php?userid=8929
View this thread: https://forums.netiq.com/showthread.php?t=55085

0 Likes
16 Replies
Highlighted
Absent Member.
Absent Member.


tfechner;264454 Wrote:
> HI,
> yes. the tcpdump shows that only a short packet is sent to the DB, the
> ascii-decode shows no readable text.
> I seem to me that the tcp connection to the db is opend, a query sent
> and after this the connection is beeing kept alive. A next query is
> scheduled to the given time ( at my connector 30 min later).


That's generally the behavior of any good JDBC/ODBC API; there is a lot
of overhead with creating/tearing down a connection. The connector is
designed around short-term polling, which is likely why we're keeping it
alive, but that along shouldn't really be an issue.


--
brandon.langley
------------------------------------------------------------------------
brandon.langley's Profile: https://forums.netiq.com/member.php?userid=350
View this thread: https://forums.netiq.com/showthread.php?t=55085

0 Likes
Highlighted
Absent Member.
Absent Member.


tfechner;263998 Wrote:
> we could reopen or recreate a SR.
> But as our DB2-Connectors are pretty much customized we need the
> solution from the developer to add the changes to our version.


Out of curiosity, how much of those customizations are specific to your
internal needs/business rules vs. flaws in what we provide out of the
box that you have cleaned up/smoothed over?


--
brandon.langley
------------------------------------------------------------------------
brandon.langley's Profile: https://forums.netiq.com/member.php?userid=350
View this thread: https://forums.netiq.com/showthread.php?t=55085

0 Likes
Highlighted
Absent Member.
Absent Member.


brandon.langley;264045 Wrote:
> Out of curiosity, how much of those customizations are specific to your
> internal needs/business rules vs. flaws in what we provide out of the
> box that you have cleaned up/smoothed over?


To audit the DB2 you need to connect to 6 different tables on one
database:

Audit, context,execute,objmaint,secmaint,sysadmin.
Each of these DB have a specific sql-statement to fetch the data.
Therefore you need 6 different collectors.
Each collector has its own parsing sequence and different sentinel-field
to fill.
As the timestamp of the last data-raw of the audit data is not stored in
the event source server but int the collector you need for each
audit-table one connector, collector and event-source-server.
That is for one datasbase: 3 sentinel-objects per table , 6 tables = 18
object.... and... we have 70 databases....

Our consultant one year ago copied the official db2-connector and
implemented the logic into the release.js file. Hi did not use custom.js
because in release.js there is too much old code to fit our needs and
database query fields. The event time does nto care about the
milliseconds of the audit event, some additional fields are not included
etc.
So we removed this code and put our code inside.

Torsten


--
tfechner
------------------------------------------------------------------------
tfechner's Profile: https://forums.netiq.com/member.php?userid=8929
View this thread: https://forums.netiq.com/showthread.php?t=55085

0 Likes
Highlighted
Absent Member.
Absent Member.


tfechner;264146 Wrote:
> To audit the DB2 you need to connect to 6 different tables on one
> database:
>
> Audit, context,execute,objmaint,secmaint,sysadmin.
> Each of these DB have a specific sql-statement to fetch the data.
> Therefore you need 6 different collectors.
> Each collector has its own parsing sequence and different sentinel-field
> to fill.
> As the timestamp of the last data-raw of the audit data is not stored in
> the event source server but int the collector you need for each
> audit-table one connector, collector and event-source-server.
> That is for one datasbase: 3 sentinel-objects per table , 6 tables = 18
> object.... and... we have 70 databases....
>
> Our consultant one year ago copied the official db2-connector and
> implemented the logic into the release.js file. Hi did not use custom.js
> because in release.js there is too much old code to fit our needs and
> database query fields. The event time does nto care about the
> milliseconds of the audit event, some additional fields are not included
> etc.
> So we removed this code and put our code inside.
>
> Torsten


It sounds like we're missing pretty badly on the important use cases for
this data source. Would you be willing to share any of what you have
so that we can look at including it in the next release of this
collector?

Thanks,
Brandon


--
brandon.langley
------------------------------------------------------------------------
brandon.langley's Profile: https://forums.netiq.com/member.php?userid=350
View this thread: https://forums.netiq.com/showthread.php?t=55085

0 Likes
Highlighted
Absent Member.
Absent Member.


brandon.langley;264208 Wrote:
> It sounds like we're missing pretty badly on the important use cases for
> this data source. Would you be willing to share any of what you have
> so that we can look at including it in the next release of this
> collector?
>
> Thanks,
> Brandon


We had a long development time and continuous improvment -- tkaes time
and money.
Therefore I am not allowed to share the whole source code here after
having talked to my manager.


--
tfechner
------------------------------------------------------------------------
tfechner's Profile: https://forums.netiq.com/member.php?userid=8929
View this thread: https://forums.netiq.com/showthread.php?t=55085

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.