Go Premium for a chance to win a PS4. Enter to Win

x

IBM System i

3K

Solutions

2K

Contributors

IBM i, formerly known as AS/400, is a proprietary, midrange, object-based operating and application system. It includes a relational database, a menu-driven interface, support for multiple users, block-oriented terminal support and printers, and supports security, communications, and web-based application servers including Websphere, Apache and Tomcat.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hi,

I am having issues restoring a library or objects using RSTOBJ or RSTLIB commands. The restore normally takes 13-17 minutes, however, its taking 8-12 hours.  The save includes ACCPTH(*YES) so it shouldn't take too long to restore. Ironically, whenever, I save the same library using the SAVLIB command, it takes 13-20 minutes. But to restore is a nightmare.

Please help me with this. I have checked sysval (System Values) for access path and other sysval for restoring objects like verify objects with digital signatures, converting objects etc. All those sysval based on my research seem to be correct.

I have a feeling it has to do with journaling. However, I am not sure. The message I got from the log were:
1. New format X was created for the file because sharing of fomat X with file X in Library Y could not be established again. It could be dependencies (logical files).
2. We encountered an error message CPF3281
3. File X in library Y using format X with a correct format level identifier does not exist.  

Please in whatever way you can HELP!

Regards,
Prince
0
[Webinar] Cloud and Mobile-First Strategy
LVL 11
[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Hi experts,

Trying to create the DS below, but get a compile error on subfield "Select", when I change it in e.g. iSelect it's ok.
I understand that Select is probably a reserved word, but I need this for my WSDL generation.

Dcl-Ds InDs Qualified;       
   Select Char(10);          
   Info Char(10);            
   Dcl-Ds Details;           
      Detail_LENGTH Int(5);  
      Dcl-Ds Detail Dim(10); 
         DetailText Char(25);
         DetailCode Char(10);
      End-Ds;                
   End-Ds;                   
End-Ds;                      

Open in new window

0
Greetings iSeries Gurus,

I just successfully set up SSL for an iSeries Access 5250 Emulation connection...
I need to know what port is used by the System i Navigator when it connects to the iSeries...

I know that Telnet uses port 23, FTP uses port 21, and SSL uses port 992 for their connections...
(Curious to note that port 992 is not showing as open on the iSeries...)

Thanks,
Jeff
0
Hi,

I have a problem via SQL and into RPG too when I type SUBSTR(xxxx,1,6)
from some reason on my iSeries it requesting to be one space between comma and lengths e.g. substr(xxx, 1, 6).
I know that on other iSeries it's not a problem and on more examples it is not written with these spaces...

This is the error message when I check

Select * from ztrans0p                    
 where substr(trcrd#,1,6) = '516971'        
 Token ,1 was not valid. Valid tokens: ) ,.
   

Message ID . . . . . . :   SQL0104                                            
                                                                               
                                                                               
Message . . . . :   Token ,1 was not valid. Valid tokens: ) ,.                
                                                                               
Cause . . . . . :   A syntax error was detected at token ,1.  Token ,1 is not  
  a valid token.  A partial list of valid tokens is ) ,.  This list assumes    
  that the statement is correct up to the token.  The error may be earlier in  
  the statement, but the syntax of the statement appears to be valid up to    
  this point.                                                                  
Recovery  . . . :   Do one or more of the following and try the request again:
    -- Verify the SQL statement in the area of the token ,1. Correct the      
  statement.  The error could be a …
0
Hi Experts.
I am doing work for a manufacturer.  They have email that is hosted by the ISP, so it is not in house.
I have a legacy system (AS400/iseries) that is in-house that I am sending emails out to vendors for Purchase orders.  The system creates PDF's then creates the email and sends out.  So it does not go thru the regular email system.    
So, we have had some emails not get delivered and some bounce back.  I have gone thru the option to tell Office 365 to whitelist the ip address we are sending from.    
The question is, Can we tell the world that our IP is safe via DNS in some way?   Otherwise, we are going to have to send emails to companies that we get kickbacks from and request that they white list us.  Issue is small now, but I am getting ready to add customer service to emailing invoices, etc too and it is only going to get bigger.
0
One of our developers has asked that we run a script that they wrote every 3-5 minutes on our iSeries.  The script is set up to see if a particular port is open - and if it isn't, then to start their application.

The script is a .sh (monitor.sh) file located in the IFS.

Is there any easy way to do this?
0
What is the difference between SAVLIB for *NONSYS, *IBM and *ALLUSR?
How do we do complete disaster recovery test? Just need sample example with steps
Why should we need to run UPTPTDINF during a complete system recovery after library QGPL has been restored
Why do we install PTF? What are the difference between cummulative, group and Hyper PTF
0
Hello Team,

Could you please tell me the difference between IPL Type A and IPL Type B? IPL B is used for routine work like ...PTF , LICPGM installation , Post monthly backups and for free up some space .... so what is the purpose of IPL A ?

on what scenarios we use IPL Type C?

Regards
Avinash Chandra
0
Hello Team,

Request you to answer the below questions

1.) What is Save while act in AS400 and How does it works?
2.) TEST LPAR was unfortunately shutdown and need to restart the LPAR with Restricted state? Does it possible ? i think we should remove the QSTRUPPGM value to *NONE and then restart the system to bring it in Restricted state , but that is not possible when LPAR is in inactive state
3.)what do you mean by Audits in MIMIX
4.) How do we check the Boot Load is TAP01 or not before initiating the IPL : Manual, D for recovery the system from bull backup tape
5.) on what scenarios we use End batch restricted state option in DST?
Regards
Avinash Chandra
0
I have a call program...example: CALL PGM (DELTE/RECV)...that I want to run in two different environments...Production (PROD2) and Test (TEST2).  My question is...how can I specifically run the program separately in both environments.  In other words, I want to run it in test, then run it in production.  Thank you in advance for your assistance!
0
Hire Technology Freelancers with Gigs
LVL 11
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

I have a number of database files on our IBM i that I need to update the authority on for our developers to *USE. Unfortunately these files are pretty much in use 100% of the time.

Is there ANY way that authority can be updated on a file without having an exclusive lock on the file? I am not aware of any - but thought I would check with others to make sure I wasn't overlooking something.

Thanks in advance
0
We have a AS400 server which is running v5r4 of the OS. It has an integrated windows 2003 server. To get antivirus installed in the windows 2003 server we had to make some registry modifications. The original registry settings were backed up. When the windows 2003 starts it blue screens and says the windows session manager cant start. We have already tried "Last know good configuration" and "Safe mode". Both of these yield the same blue screen. If we could only boot from a CD and run windows restore or some utility to re import the registry settings. But there seems to be no way to tell the AS400 to boot the integrated server from the CD instead of the hard drive.  Please HELP.
0
We have a AS400 server which is running v5r4 of the OS. It has an integrated windows 2003 server. The windows server install got corrupted and is down.  We would like to pull the data of of the windows install without the windows 2003 server running.  Is it possible? Since the disks are integrated between the AS400 and windows I thought it might be possible since the Windows drive are showing up as AS400 virtual disks with the integrated server being off.
0
We have a AS400 server which is running v5r4 of the OS. It has an integrated windows 2003 server. The windows server install got corrupted and is down.  Is it required for QNTC to work on the AS400?
0
Hi Team,

I would like to know the difference between Virtual Printer vs. Remote Printer vs. LAN Printer and in what scenario we use these printers and how do we configure Virtual Printer and Remote printer in AS400 . Please help me with commands.

Regards
Avinash Chandra
0
Greetings,

I have a disk full condition which caused a V7R1 Power5 to shut down...
Need to know the procedure for IPLing to delete some stuff...

Someone said to IPL from the A side...
Is that true...?
Is that A Normal or A Manual...
0
We are FINALLY looking to retire our 'Office Vision' email. I'm looking for a way to dump the email detail for every email we currently have. The intent would be parse this information into a database for historical purposes.  

I've used QRYDST to dump header information, but I need all details.

Can anyone provide direction on this? Is it possible?

Thank You!!!
0
Error details : CWBLM0031 - failure, a data conversion error was returned by the host server. rc1=2 rc2=21,I am using PC EMULATOR 5250 PERSONAL COMMUNICATION ,I am accessing it via remote ,Now whenever I am logging in to it ,I am having this error.I amnot able to log in.
Please help.
0
I want to create user who is going to see all the user profile and group profiles but should not having access to changes or delete any thing on AS400 machine.

To achieve this i have created User having following permissions-

User class           - *USER
Special authority - *ALLOBJ
 
With this user, we can read all user profiles from IBMi machine, but due to *ALLOBJ, this user profile may have access to few other commands -

Perform Read only operations.
Add or Remove User to an Authorization List.
Revoke Object Authority.
Change own password i.e. Self password change.
I want restrict all these command to execute on IBMi machine.

My main requirement is to create a user having very minimum permissions means who can only read data from IBMi machine and do not have capability to change any thing.

If any one is having any idea about this please share.
0
What is SQL Server and how does it work?
LVL 1
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Hi,

I have taken on the management of a system that runs on an as400 and was looking to get some training online. Can someone recommend a training course?

Best

Ross
0
I research the official document about commands RCVJRNE and QSNDDTAQ in the IBM knowledge center. But I just find the introduce about the parameter.
The example is just simple and doesn't contain that send data to data queue using RCVJRNE. So please help me.
The follow is the RPG file.
     DDQNAME           S             10A   INZ('DTAQTEST')
     DDQLIB            S             10A   INZ('xxxxxxxxx')
     DDQSNDLEN         S              5  0 INZ(100)
     DDATLEN           S              3  0 INZ(0)
     DDATKEY           S             10A
     DASYREQ           S             10A   INZ('*NO')
     DDATJRN           S             10A   INZ('*YES')
     DDQSNDDATA        S            100A
     D*
     DDQLEN            S              5  0
     DDQTYPE           S              1A
     D*
     C*************************************
     C* Main Logic
     C*************************************
     C*
     C     *ENTRY        PLIST
     C                   PARM                    DQSNDDATA
     C                   PARM                    DQTYPE
     C
     C                   CALL      'QSNDDTAQ'
     C                   PARM                    DQNAME
     C                   PARM                    DQLIB
     C                   PARM                    DQSNDLEN
     C                   PARM                    DQSNDDATA
     C                   PARM                    DATLEN
     C                   PARM                    DATKEY
     C                   PARM         

Open in new window

0
iSeries is successfully sending out emails, but spam filtering rules prevent the receipt of mail issued from the iSeries bearing the same domain name.  The only solution would be to route the outbound mail through the local exchange server.
What settings need to be altered on the iSeries to point the outbound SMTP traffic to the local Exchange Server?
0
I am trying to login. I am using correct information.
0
Hi

I am trying to configure a Xerox Phaser 6180 MFP to work on an IBM AS400. the configuration is accepted but I keep getting the message "remote device rejected an attempt by the writer to open a connection"
I have it configured as a
Device Type:  3812
Model: 1
Port: 9100
Manufacturer Type and Model:   *HP5SI
Remote Location:  192.168.5.50
System Driver Program:  *HPPJLDRV

Can anyone advise.

Regards
Gerald
0
I am working on a program in the CAPS (claim medical processing system) software.  It allows the user to enter claim information.  In the program claim information is written to files.  Before the claims entry screen is displayed, the program creates a backup of all the information for the patient.  This involves making copies of data in 5 different files in qtemp.  

If the user decides not to continue with the claim and backs out, the program removes all of the information in the 5 files for the patient being processed.  It then copies back the data that had been saved.  The problem with this is that on more than one occasion the claim entry screen ended before the information was copied back.

My manager has selected that we try commitment control.  But from what I have read this may not be the best choice.   Can anyone tell me if I am correct or can this be used?

Thank you
0

IBM System i

3K

Solutions

2K

Contributors

IBM i, formerly known as AS/400, is a proprietary, midrange, object-based operating and application system. It includes a relational database, a menu-driven interface, support for multiple users, block-oriented terminal support and printers, and supports security, communications, and web-based application servers including Websphere, Apache and Tomcat.

Top Experts In
IBM System i
<
Monthly
>