Well not just letters of the alphabet it seems. Take the case of the logstash pattern WORD: WORD \b\w+\b but the shorthand character class \w matches [a-zA-Z0-9_] – notice the digits and underscore! So WORD is not really a WORD! REALWORD \b[a-zA-Z]+\b would be better … although I suppose things might be different in Unicode. […]
Archive for the ‘Languages’ Category
Placeholder for useful code snippet: open my $fh, ‘<:raw:perlio:encoding(UTF-16LE):crlf’, $filenameopen my $fh, ‘<:raw:perlio:encoding(UTF-16LE):crlf’, $filename which will convert CR/LF combinations to LF only. Alternatively, to keep them intact: open my $fh, ‘<:raw:perlio:encoding(UTF-16LE)’, $filenameopen my $fh, ‘<:raw:perlio:encoding(UTF-16LE)’, $filename Useful for reading Windows registry export files, SQL server log export files etc.
There are many ways possible ways to collect logspace usage data from SQL Server – this was a quick way using the tools I had at hand – DBCC, perl, elastic search and kibana. All I did was capture the output of: DBCC SQLPERF(logspace) into a temporary table using a simple perl script using DBI. […]
I just used the java Math library ceil function from PeopleCode to solve the “round to nearest 0.5” problem e.g. 1 2 3 4 5 6 7 8 9 10 11 Local JavaObject &mathclass; Local number &number_to_round, &result; /* Instantiate java Math class */ &mathclass = GetJavaClass("java.lang.Math"); For &number_to_round = 0.1 To 2.0 […]
Way back in 1998 I was implementing PeopleSoft Financials 7.5 for a UK Charity. SQR and Application Engine (the COBOL version back then) were the only options available in the PeopleSoft toolset for updating the database. Other than straight SQL updates in SQLPlus of course! Whilst SQR was an OK tool, I always felt it […]
When increasing the Java VM memory parameters for a PeopleSoft system under Weblogic (either in setEnv.cmd or manually by editing the cmdline registry entry if that’s your “thing”), be very careful not to increase the -XX:MaxPermSize memory allocation too much. In fact I would leave it at 128MB or perhaps 256MB. Whatever you do, don’t […]
I have spent some time looking into Elasticsearch, Logstash and Kibana (ELK) for analysis of PeopleSoft web, application and process scheduler log files. Whilst commercial solutions exist that can be configured to do this, they all seem somewhat over priced solutions to a relatively common and essentially simple problem – log file shipping, consolidation/aggregation and […]