Messages

106

z/OS Server / Re: AFPDS TO CMOD

« on: October 22, 2009, 03:42:26 AM »

I don't think you can pick your index data using the report wizard menu. It is better to create the AG and Appliation Manually and supply the ACIF indexing information.

The data files should have the index field as TLE in it.

Knock me if u require more explanation.

107

Windows Client / Re: FONT MAPPING

« on: August 04, 2009, 04:06:05 AM »

Great... Hope u can have a great vacation for the year

108

Windows Client / Re: FONT MAPPING

« on: July 15, 2009, 07:38:34 AM »

Hi Lazosa,
I believe all the font files defined in CPDEF.FNT, CSDEF.FNT, ICODED.FNT need to be installed in all the computer to get the proper view

109

Windows Client / Re: FONT MAPPING

« on: July 14, 2009, 03:10:46 AM »

Hi Lazosa,
      A question out of curiosity... does the other computers which has the CMOD thick client has those Greek fonts installed?

110

Windows Client / Re: Session Stats

« on: July 03, 2009, 05:51:12 AM »

I believe you can calculate it from the system log table.

Msg No : 30 -> Conveys login action and
Msg No : 32 -> Conveys logoff action

From the time difference between this two we can find how log the session was open

111

Documentation / Re: Update/Upgrade notifications

« on: March 17, 2009, 02:14:52 AM »

I am not sure of mail alerts... But still you can check this link if any updates on fixes is available.

ftp://service.software.ibm.com/software/ondemand/fixes/

112

MP Server / Re: Delete large volume of data from OnDemand

« on: December 24, 2008, 11:03:03 AM »

Paula,

Here are the choices...

1. Check if the documents have crossed their expiration period has be crossed then it is a better idea to run ARSMAINT manually, which would delete the data automatically.

2. If you require all the data to be in the application group then it would be better you delete the application group.

3. If you require some of the data to be deleted in the application group, then it is better to collect the load ids of all the loads and run it as a batch script in the host side scripting using arsadmin.

The impact of deleting/unloading could be you can never get back those data

113

Other / Re: Windows Admin Client - Folder/Application Mapping

« on: December 24, 2008, 10:43:18 AM »

Lorelei,
I feel this would be a better way if u are aware with bit of SQL.

There are 3 table which have this information
1. ARSAG - List of application groups available
2. ARSFOL - List of Folders available
3. ARSAG2FOL - List of folder mapping

these 3 tables can be concatenated and the required information can be retrieved.

114

z/OS Server / Re: Any exit to convert report from EBCDIC to ASCII

« on: November 25, 2008, 07:17:13 AM »

Try out this table to convert

        0,  1,  2,  3,156,  9,134,127,151,141,142, 11, 12, 13, 14, 15,
         16, 17, 18, 19,157,133,  8,135, 24, 25,146,143, 28, 29, 30, 31,
        128,129,130,131,132, 10, 23, 27,136,137,138,139,140,  5,  6,  7,
        144,145, 22,147,148,149,150,  4,152,153,154,155, 20, 21,158, 26,
         32,160,161,162,163,164,165,166,167,168, 91, 46, 60, 40, 43, 33,
         38,169,170,171,172,173,174,175,176,177, 93, 36, 42, 41, 59, 94,
         45, 47,178,179,180,181,182,183,184,185,124, 44, 37, 95, 62, 63,
        186,187,188,189,190,191,192,193,194, 96, 58, 35, 64, 39, 61, 34,
        195, 97, 98, 99,100,101,102,103,104,105,196,197,198,199,200,201,
        202,106,107,108,109,110,111,112,113,114,203,204,205,206,207,208,
        209,126,115,116,117,118,119,120,121,122,210,211,212,213,214,215,
        216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,
        123, 65, 66, 67, 68, 69, 70, 71, 72, 73,232,233,234,235,236,237,
        125, 74, 75, 76, 77, 78, 79, 80, 81, 82,238,239,240,241,242,243,
         92,159, 83, 84, 85, 86, 87, 88, 89, 90,244,245,246,247,248,249,
         48, 49, 50, 51, 52, 53, 54, 55, 56, 57,250,251,252,253,254,255

If you need the complete script plz let me know.

Rick
=========
www.rick.co.in

115

Report Indexing / Re: Report Name problems

« on: November 25, 2008, 06:28:14 AM »

Does the document has the these database values (LC65-001 or LC65-002) ? if not the unique value in the document can be given to idenfity the reprot and load it.



Rick
===========
www.rick.co.in

116

MP Server / Re: statistics report

« on: November 19, 2008, 01:05:07 AM »

here www.raptor4.com you can find the reporting tool for managers and for administrators

117

z/OS Server / Re: arsdate within batch program

« on: November 17, 2008, 07:26:14 AM »

yes it can be done...

if you are using C program, use system function to call it

If you are using dos script, it can be called from the location of arsdate (eg: C:\Program Files\IBM\OnDemand for WinNT\bin\arsdate.exe)

If you are using unix scripting, it can be invoed in /usr/lpp/ars/bin

Rick
www.rick.co.in

118

z/OS Server / Re: How do i re-archive AFP data (ardoc get,unload and load)

« on: November 17, 2008, 07:22:40 AM »

I have tried this and it worked.

Step 1:

arsdoc get -h 127.0.0.1 -u username -p password -d directory_name -g -a -N -c -v -G AG_Name -i "where applid ='Application_id'" -o output_file_name -x Load-id

Step 2:

arsadmin load -h 127.0.0.1-u username -p password -d directory_name -g New_AG_Name -a New_App_name -i index_file_name -s data_file_name -r resource_file_name

Step 3:

arsadmin unload -h 127.0.0.1-u username -p password -g old_AG_name -N -L Load_id

This had loaded the AFP data fine to new server retriving from old server.

Rick
www.rick.co.in

119

General / Re: Question

« on: November 17, 2008, 07:10:45 AM »

Here is a way for it.

In storage node in AG,

1. Select the archival storage node
2. choose the option "Cache data for 730 days"
3. In life of data and indexes choose "Expire in 2555 days"
4. So after 7yrs the data can be archived in anual backup tape .

Rick
www.rick.co.in

120

General / Re: Using OnDemand to store DDL and/or Historical Data

« on: November 17, 2008, 06:58:11 AM »

r you looking to migrate a historical database to the ondemand?