Code400 -The Support Alternative - Iseries System administration http://www.code400.com/forum/ Anything that deals with system administration. en Tue, 07 Sep 2010 00:55:11 GMT vBulletin 60 http://www.code400.com/forum/images/misc/rss.png Code400 -The Support Alternative - Iseries System administration http://www.code400.com/forum/ Discussion! (Compile Options) http://www.code400.com/forum/showthread.php/9625-Discussion!-(Compile-Options)?goto=newpost Thu, 02 Sep 2010 13:00:47 GMT I wanted to start this discussion for consideration of Optimization and Performance Utilization of the iSeries (i5, Power 7, AS400, Black Box... insert your latest name here). I would love to re-examine our company defaults for compiling and/or OVRDBF Sequential Processing as well as for (and... I wanted to start this discussion for consideration of Optimization and Performance Utilization of the iSeries (i5, Power 7, AS400, Black Box... insert your latest name here).

I would love to re-examine our company defaults for compiling and/or OVRDBF Sequential Processing as well as for (and compared to) SQL processing. Keeping this in mind, my first direction was to look at some of our longest running jobs and see what we can do to improve system performance on those jobs (without programming changes).

One particular job runs at 22:00. It is sequential based and can run anywhere from 1.5 hours to 3.5 hours (depending on that day's work). It does process data from multiple huge (30 million+) tables and populates several interface files for updating other systems.

In looking at this situation, the current program is CBL. I changed the type to CBLLE and changed the OPTION to use *BLK
Code:
*BLK                                                                 
    When *BLK is used and a BLOCK CONTAINS clause is specified, the 
    compiler allows blocking for DYNAMIC access files and SEQUENTIAL 
    access files with a START statement.  Blocking is not allowed for
    RELATIVE files opened for output operations.  The BLOCK CONTAINS 
    clause controls the number of records to be blocked.             
                                                                     
    When *BLK is used and no BLOCK CONTAINS clause is specified, the 
    compiler allows blocking only of SEQUENTIAL access files with no 
    START statement.  The operating system determines the number of 
    records to be blocked.
At this point, I addressed the OVRDBF of the huge tables that are being read sequentially and calculated the optimal block size (based on 128k) and changed the command to include the SEQONLY(*YES xxxx) -- this is taking the value 131073/Record Size of huge table. (128K Block)

After making the above changes, I recompiled the source (the OVRDBF was performed within the CBBLE program).

My original baseline test on the nightly job mentioned was 1 hr 55 minutes. After making the changes mentioned above, I re-ran the same nightly job. My completion time was 1 hr 06 minutes! (A 41% decrease).

So, I tell you all this to get feedback on your optimal compile/usage techniques ... but, I would like this to include SQL processing as well. I'm in the *very* early stages of convincing the company to utilize the SQL processing of the iSeries and I would like some tried & true recommendations to back up the usage of SQL and how to go about taking advantage of it. (OK Biggs .. here's your stage! :D)

Not to mention, this might help others that are out there with Legacy systems or have programmers that retired back in 1987 but don't realize it. I know this system can be *fine tuned* toward taking advantage of things like the Blocking, etc... I would just like to find an optimal "base" to begin knowing that I'm giving the system a fighting chance at performing to it's ability.

Please, NO WAGERING! Only (System) Performance Enhancing Drugs (Options) are allowed!

:D ]]> Iseries System administration FaStOnE http://www.code400.com/forum/showthread.php/9625-Discussion!-(Compile-Options) Need your help for data synchronization http://www.code400.com/forum/showthread.php/9619-Need-your-help-for-data-synchronization?goto=newpost Wed, 01 Sep 2010 10:34:54 GMT Hi, I have two servers one is production and the other is dev. i want all the files in some set of libraries in dev server to be in sync with prod server. 1) around 50 libraries are in production server 2) each libraries have more than 200 files in it 3) each files have lakhs of record my... Hi, I have two servers one is production and the other is dev. i want all the files in some set of libraries in dev server to be in sync with prod server.

1) around 50 libraries are in production server
2) each libraries have more than 200 files in it
3) each files have lakhs of record

my idea is to, run a batch CL pgm
1) which will read a configuration file having the list of libraries and files to be synchronized
2) clear the file available in DEV server
3) establish a DDM connection with PROD server for that file
4) copy the file from prod to DEV
5) read next file from the configuration file and repeat from step 2

so as such, i have to establish more than 1000 ddm connection on one run
1) does this affect system performance?
2) is this method advisable

more dangerous part of it is: i have to do such synchronize data from 16 production into dev server with diffeerent set of libraries

is there any other way to do this rather going for a tool. please advise

Regards
Regu ]]> Iseries System administration regu400 http://www.code400.com/forum/showthread.php/9619-Need-your-help-for-data-synchronization User Login History http://www.code400.com/forum/showthread.php/9537-User-Login-History?goto=newpost Thu, 12 Aug 2010 07:56:33 GMT Hi All, How do check a particular user login history at particular time? Please help. Thanks in advance. rgds, Hi All,

How do check a particular user login history at particular time?
Please help.
Thanks in advance.

rgds, ]]> Iseries System administration ronny_nch http://www.code400.com/forum/showthread.php/9537-User-Login-History FTP -- SSH Connection to iSeries http://www.code400.com/forum/showthread.php/9517-FTP-SSH-Connection-to-iSeries?goto=newpost Thu, 05 Aug 2010 18:27:18 GMT Has anyone had experience with making this connection?

Specifically... need to make sure I do/don't need to have a certificate loaded that validates connection. Or, can I just utilize a UserID/PW to validate?

Examples? Direction?

Thanks!! ]]> Iseries System administration FaStOnE http://www.code400.com/forum/showthread.php/9517-FTP-SSH-Connection-to-iSeries Virtual Tape in ASP2 http://www.code400.com/forum/showthread.php/9515-Virtual-Tape-in-ASP2?goto=newpost Thu, 05 Aug 2010 14:03:00 GMT I am setting a new system, and I finally have one with enough storage to create a 2nd ASP. OK, ASP # 2 is created. I know how to setup a Virtual Tape, but where or how do I specify that I want it in ASP # 2 instead of the System ASP ? I am setting a new system, and I finally have one with enough storage to create a 2nd ASP. OK, ASP # 2 is created. I know how to setup a Virtual Tape, but where or how do I specify that I want it in ASP # 2 instead of the System ASP ? ]]> Iseries System administration arrow483 http://www.code400.com/forum/showthread.php/9515-Virtual-Tape-in-ASP2 Data synchronisation tool - need your expert advise http://www.code400.com/forum/showthread.php/9503-Data-synchronisation-tool-need-your-expert-advise?goto=newpost Wed, 04 Aug 2010 05:27:16 GMT Hi, Our client currently needs a data synchronization tool that should synchronize data base from one server to another server. They doesnt worry about the cost. They need a quality tool. They already had Mimix for some servers but looking for something better than that. Could you please share... Hi,

Our client currently needs a data synchronization tool that should synchronize data base from one server to another server. They doesnt worry about the cost. They need a quality tool. They already had Mimix for some servers but looking for something better than that. Could you please share your expert idea on this. In net, I searched for tools like DBmoto, SDR but looking for your guidance before advising my client to purchase

Regards
Regu ]]> Iseries System administration regu400 http://www.code400.com/forum/showthread.php/9503-Data-synchronisation-tool-need-your-expert-advise MIMIX - RTVDGSTS help ... http://www.code400.com/forum/showthread.php/9498-MIMIX-RTVDGSTS-help-...?goto=newpost Mon, 02 Aug 2010 12:22:40 GMT Is anyone else out there using MIMIX for database/object replication ?

We have several datagroups, and the WRKDG screen shows a nice overview (apart from having to page down to see the rest of the DG's), and it shows the status (*ACTIVE etc) and it shows errors (DB and File), but it does not show if there is any backlog pending.

I am looking at a few utilities for switching the MIMIX datagroups, and wanted a program to check the MIMIX status.

I am looking at RTVDGSTS as below, but I am not sure what the fields actually tell me.

Code:
  RTVDGSTS  DGDFN(&DGNAME &LclSys &RmtSys) + 
            DTASRC(&DTASRC) +             
            TFRSTS(&TFRSTS) +             
            DBSNDBKLG(&DBSNDBKLG) +       
            OBJSNDBKLG(&OBJSNDBKLG) +     
            OBJRTVBKLG(&OBJRTVBKLG) +     
            CNRSNDBKLG(&CNRSNDBKLG) +     
            OBJAPYBKLG(&OBJAPYBKLG) +     
            OBJERR(&OBJERR) +             
            FAILOBJENT(&FAILOBJENT) +     
            ACTOBJENT(&ACTOBJENT)
This is of course a subset of what RTVDGSTS can tell me. My DG have both object and DB entries, and I need to see if everything is replicated over before I switch.

I can do this manually through the WRKDG screen, but this takes a few minutes, and I wanted a faster switch, so this can tell me *something* a lot faster. Is my assumption that the fields below should return thus, and therefore indicate that I am in a good clean place to switch from.

Or do i need more data than this ?

DTASRC - Tells me the direction the DG is currently replicating.
TFRSTS - should be *ACTIVE
DBSNDBKLG - should be 0
OBJSNDBKLG - should be 0
OBJRTVBKLG - should be 0
CNRSNDBKLG - should be 0
OBJAPYBKLG - should be 0
OBJERR - should be 0
FAILOBJENT - should be *NO
ACTOBJENT - should be *NO

Repeat for all DG required ... ]]> Iseries System administration gcraill http://www.code400.com/forum/showthread.php/9498-MIMIX-RTVDGSTS-help-... <![CDATA[Can't Delete Physical File -- Phantom Logical]]> http://www.code400.com/forum/showthread.php/9480-Can-t-Delete-Physical-File-Phantom-Logical?goto=newpost Tue, 27 Jul 2010 18:14:40 GMT Here's what happened:
1) I started to do a RSTLIB
2) Realized I had the wrong tape so I cancelled the job.
3) I can't delete the libr because there's a file that thinks there's a logical attached to it.
4) If I do DSPDBR on the file, it shows a dependent file, but the library name is blank.

:duh ]]> Iseries System administration Chipper http://www.code400.com/forum/showthread.php/9480-Can-t-Delete-Physical-File-Phantom-Logical Telnet SSL http://www.code400.com/forum/showthread.php/9471-Telnet-SSL?goto=newpost Mon, 26 Jul 2010 06:50:13 GMT Hello I am working on connecting Telnet session with SSL, it is working fine. BUT, i need to create a log or report for the connection, i tried to use the QAUDJRN to check on the local port but it does not show it, it only shows the remote port and IP address. How can i create such a... Hello

I am working on connecting Telnet session with SSL, it is working fine.

BUT, i need to create a log or report for the connection, i tried to use the QAUDJRN to check on the local port but it does not show it, it only shows the remote port and IP address.

How can i create such a report or log for the connections, even if it is only based on the job??

only the admins need to connect through SSL but i need to verify that by a report.

Maybe we can use an API on the initial program for the admins (although i dont recommend it where the admin can change his user profile), but still the API thing is very complicated.

any help??

thanks ]]> Iseries System administration ABAdmin http://www.code400.com/forum/showthread.php/9471-Telnet-SSL Object Ownership http://www.code400.com/forum/showthread.php/9465-Object-Ownership?goto=newpost Fri, 23 Jul 2010 16:14:12 GMT How do you control systemmatically the ownership of an object? At my last employer, when the programmers compiled programs the system automatically assigned XYZOWNER as the object owner of the created program. I have not figured out how to do this and I'd really like to understand how to do this. I have user profiles of past programmers that haven't been with this company for over 5 years still on the system because they own over 1000 objects on the system.

With us going to a new 400 I'm trying to get the system cleaned up so we no longer have to deal with things like this and I was wondering if anyone knew what to do.

Thanks! ]]> Iseries System administration NYCountryGal http://www.code400.com/forum/showthread.php/9465-Object-Ownership