46
z/OS Server / Re: CMOD Extraction of data
« on: July 03, 2018, 05:00:29 AM »
One question I would ask is how is the data currently stored? OAM? Cache? If Cache we've shortcutted the process by using ARSADMIN STORES.
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.
47
Other / Re: Message Number 61 and Ambiguous Results
« on: June 20, 2018, 05:06:43 AM »
Message 61 is simply a record of what you updated when you made the changes to the indexer parameters. It always comes out with two records, one is viewable the other is not. This is unrelated to your load issues. If you could provide us the contents of your 88 record we may be able to help.
48
z/OS Server / Re: Manifest print style
« on: June 11, 2018, 05:37:10 AM »
Just a shot in the dark. We had a similar issue (we're on 9.5) where the manifest was being generated with a different RecFM than the rest of the output therefore the top of form was never going to be recognized. If you're on 9.5 see if you have PTF UI50164 applied
49
Documentation / Re: Retention Changes
« on: May 21, 2018, 05:40:15 AM »
If you're on z/OS and using OAM there is a way to put a hold on the expiration. Of course the best way to handle this is to reload into a new application group but we've used the hold method to stop documents from being expired while we work on the solution.
50
Report Indexing / Re: INDEX vs Filter
« on: May 10, 2018, 06:33:30 AM »
The more Indexes you add the more space you will consume. If you're not space constrained I wouldn't concern myself too much with the number of Indexes you have defined as the benefits generally outweigh the negatives. I wouldn't change all 20 to Index but we usually start with 4 to 6 Indexes and tweak it from there. We'll start small and work our way up watching resource consumption and response times. We always poll the users to find out which fields they use most, restrict the use of NOT, and when possible force them to always use at least one indexed field.
51
z/OS Server / Re: z/OS V2.3 Release Notes
« on: May 02, 2018, 10:48:13 AM »
Mind if I pick your brain on this?
How does that work? You mention changing SRVR_ODF_CFG to point to something else, in your case the Linux box. Does that mean you have a full ODF installation on that box?
How does that work? You mention changing SRVR_ODF_CFG to point to something else, in your case the Linux box. Does that mean you have a full ODF installation on that box?
52
z/OS Server / Re: z/OS V2.3 Release Notes
« on: May 02, 2018, 07:29:29 AM »
Well that's an alarming development. We currently do a lot of ODF distribution through SMTP and we're at V2.2. V2.3 is set to be done next year. Joy.
53
Report Indexing / Re: Updating multiple Indexs
« on: March 27, 2018, 05:55:07 AM »
Thinking a little outside the box. If the exit isn't going to be used by anything else possibly rewrite the exit to do nothing?
54
Content Navigator / Re: ICN question - we convert to CMOD in 2 weeks
« on: March 13, 2018, 05:53:38 AM »
We've handled converting column data to a spreadsheet by letting Excel do the work. In general:
-Save a sample file from ICN with standard name eg. rpt123.txt
-Open Excel and start a macro recording session.
-Step through importing data from text ensuring columns and data type are set correctly using sample file
-Stop recording, delete the imported data, and save the workbook as read only
As long as you save to the same file name you simply need to open the workbook, run the macro, and do a "save as..."
We sometimes set the macro to run on open so opening the particular workbook automatically imports the report. If you use bgroff's suggestion for logical views that can help as well.
Not exactly one click conversion but it is close and quicker than most other methods.
-Save a sample file from ICN with standard name eg. rpt123.txt
-Open Excel and start a macro recording session.
-Step through importing data from text ensuring columns and data type are set correctly using sample file
-Stop recording, delete the imported data, and save the workbook as read only
As long as you save to the same file name you simply need to open the workbook, run the macro, and do a "save as..."
We sometimes set the macro to run on open so opening the particular workbook automatically imports the report. If you use bgroff's suggestion for logical views that can help as well.
Not exactly one click conversion but it is close and quicker than most other methods.
55
Report Indexing / Re: How to Define a transaction report
« on: January 29, 2018, 12:59:48 PM »
If you are looking to be able to jump to specific location within a document based on account number then you may need to look into a setting up a page index, which I'm not completely familiar with. I haven't found a lot of documentation on setting up and using page indexes and haven't had a reason to ever use it.
You can use these transaction fields to search for a document that may contain that account number within it's range of account numbers.
To accomplish this you add a folder field, something like "AccountNum_Search" with the field type that matches your accountNum.
Select Mapping Type of Range.
Next in the Field Mapping, map AccountNum_Search to both Card_AccountNum and Card_AccountNum_end (do it one at a time) and add AccountNum_Search to the folder query section. Save/close
Now if you open the folder and enter 0000000000000025 into the AccountNum_Search window you will pull up any document that "should" have that number within it's range. No guarantees it will be there, just that the number falls between the beginning and end numbers of that particular document. After that you could open the doc and do a Find.
You can use these transaction fields to search for a document that may contain that account number within it's range of account numbers.
To accomplish this you add a folder field, something like "AccountNum_Search" with the field type that matches your accountNum.
Select Mapping Type of Range.
Next in the Field Mapping, map AccountNum_Search to both Card_AccountNum and Card_AccountNum_end (do it one at a time) and add AccountNum_Search to the folder query section. Save/close
Now if you open the folder and enter 0000000000000025 into the AccountNum_Search window you will pull up any document that "should" have that number within it's range. No guarantees it will be there, just that the number falls between the beginning and end numbers of that particular document. After that you could open the doc and do a Find.
56
Report Indexing / Re: How to Define a transaction report
« on: January 25, 2018, 07:16:51 AM »
For starters you would have had to define two fields for your Card_AccountNum. One to hold the beginning value and one to hold the end value eg. Card_AccountNum and Card_AccountNum_end. In your application definition under Load Information you would assign both to the load ID Name of the field you indexed on, in your case Card_AccountNum:
Application Group Database Name: Card_AccountNum --> Load ID Name: Card_AccountNum
Application Group Database Name: Card_AccountNum_end --> Load ID Name: Card_AccountNum
You then use the two fields Card_AccountNum and Card_AccountNum_end in your folder definitions to get the beginning and ending values of the transaction range.
Application Group Database Name: Card_AccountNum --> Load ID Name: Card_AccountNum
Application Group Database Name: Card_AccountNum_end --> Load ID Name: Card_AccountNum
You then use the two fields Card_AccountNum and Card_AccountNum_end in your folder definitions to get the beginning and ending values of the transaction range.
57
z/OS Server / Re: Unable to index JES2 Spool files using ARSYSPIN
« on: December 20, 2017, 06:48:51 AM »
Clearly something is wrong with the Page_Number index. Double check your definitions for that particular field. To use page number I think I recall having to check off the "page count" box for the page number field in your application group. Was that done?
58
MP Server / Re: APK346W PAGEDEF RESOURCE IS INVALID Error on Line File
« on: December 15, 2017, 06:41:18 AM »
Looks to me like you are using an input exit based on the sample you provided:
INPEXIT=/installable/IBM/ondemand/V10.1/exits/acif/asciinpe
INPEXIT=/installable/IBM/ondemand/V10.1/exits/acif/asciinpe
59
MP Server / Re: ARSLOAD for Windows input from folder
« on: November 29, 2017, 11:08:58 AM »
You are correct as this can, and has caused issues on our system. Generally speaking we now make sure the *.ard trigger files are the last files written. PDFs are moved with temp file extensions and renamed to *.pdf after they have been placed in the load directory.
60
Report Indexing / Re: PDF Report wizard
« on: November 08, 2017, 07:30:13 AM »
We had a similar issue with documents that had been converted to PDFs after being created in another format. Something with the way the PDFs were built really messed with attempts to index the document. They looked and opened with no issues but either wouldn't let us select particular text or only allowed us to select huge sections of the text. We had to have the group running the transforms redo their work.