Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - Darrell Bryant

Pages: 1 2 3 4 5 [6]
76
iSeries / Re: Stats - Report Counts etc.
« on: December 08, 2016, 01:28:23 PM »
If you are using ASM as your storage manager, you could use this SQL statement against the QARLCOIT file, which contain a row for each object stored in the instance.  In this SQL statement, the where clause selects the index objects (object name ending in 1), of which there should be one per load.

SELECT OBJECT_GROUP, COUNT(*) FROM QUSROND/QARLCOIT WHERE
TRIM(OBJECT_NAME) LIKE '%1' GROUP BY OBJECT_GROUP ORDER BY
OBJECT_GROUP

 If you are storing very large reports, you might have more than one data object name per load that ends in A.

77
iSeries / Re: Archiving Emails in OnDemand
« on: August 29, 2016, 08:52:33 AM »
Business partner 10m, located in Germany, has a product for archiving email into CMOD. The web page is in German, https://www.10m.de/odc.html, but you can use Google to translate if needed.  They are fluent in English and have done installations and services in many countries.

78
Report Indexing / Re: Date format specifiers
« on: February 23, 2016, 04:15:42 PM »
Based on a quick test, the problem is that you have two spaces between the month and the day in the string 'Feb  1 2016'.  Your date format of %b %e %Y only contains one space.

79
iSeries / Re: ADDRPTOND
« on: March 03, 2010, 08:13:35 PM »
If the user does not have a home directory, the temporary objects are created in the root ('/') directory.  Your system may be configured to prevent users from creating objects in that directory.

80
iSeries / Re: How to get Common Server load errors to QSYSOPR message queue?
« on: July 13, 2009, 11:18:21 AM »
OnDemand already sends system log message 88, and most other error messages, to QSYSOPR.  The OD error messages are sent using message OND1002.  If you display the message it will look something like the following:
Message ID . . . . . . :   OND1002       Severity . . . . . . . :   20       
Message type . . . . . :   Diagnostic                                         
Date sent  . . . . . . :   07/13/09      Time sent  . . . . . . :   14:10:25 
                                                                             
Message . . . . :   Instance 'QUSROND' sent severity 2 message number 88 for 
  user 'DBRYANT' at '07/13/09 14:10:24'.                                     
Cause . . . . . :   'ApplGroup Failed Load: Name(CHECKSTMTS) LoadId(--INDEXING
  ONLY--)                                                                     
  File(/QIBM/USERDATA/ONDEMAND/QUSROND/TMP/DB_ONDSAMPLES_FLASHSALES_FLASHSALES
  )'.                                                                         
Recovery  . . . :   Look at the OnDemand system log for instance 'QUSROND' for
  more information.                                                           
Technical description . . . . . . . . :   Account:  Log id: '33243'.         

Another option is to use the arslog exit program.  Using the arslog exit program you can decide on a message by message basis what action, if any, to take.  We include a sample arslog program in file QSAMPLES2 in library QRDARS.  An update is required to the shipped sample arslog program.  If you send me an e-mail, I will send you the updated (and enhanced) source code.

81
Documentation / Re: Update/Upgrade notifications
« on: May 12, 2009, 09:22:37 AM »
You can also subscribe to IBM e-mail notifications.
See http://www-01.ibm.com/software/data/support/einfo.html for more details.

82
iSeries / Re: Do poeple prefer arsload or use STRMONOND??
« on: February 08, 2007, 05:13:52 PM »
Yes, can remove the arsload job schedule entries and add new entries with the matching STRMONOND *DIR commands.

83
iSeries / Re: Do people prefer arsload or use STRMONOND??
« on: January 30, 2007, 10:44:39 AM »
For storing documents from Ascent Capture, STRMONOND is the easiest of the two commands to use.  It provides options to keep processed files and also to end the monitor automatically.  You can also use ENDMONOND to end the monitor, versus having to perform an endjob in order to cancel an arsload job.

The arsload command provides the option to monitor multiple directories with one job.

I hope this is helpful.

84
Report Indexing / Re: Indexing a report
« on: December 01, 2006, 01:26:44 PM »
When adding an index using the graphical indexer you can add multiple fields to the index.  They will be concatenated with no blanks, so if you need a blank between fields you will have to ensure that one is provided.  Note that there are some limitations, the OD Admin help for 'Adding an index' discusses these.

85
iSeries / Re: Do poeple prefer arsload or use STRMONOND??
« on: December 01, 2006, 12:56:29 PM »
What type of problems are you experiencing with STRMONOND?  There have been PTFs for STRMONOND during this year, but without knowing your problems I can't make a recommendation.

Pages: 1 2 3 4 5 [6]