Questions tagged [ibm-midrange]

IBM Midrange is a general term referring to the business computing platform also known as AS/400, iSeries, i5, IBM i, et al.

Originally introduced on June 21, 1988 the platform has been continually updated to support and integrate with modern technologies while maintaining source and binary compatibility.

The platform includes an integrated database server and natively supports many application servers including , and .

Common programming languages for the IBM Midrange platform include:

For more information see the Wikipedia article on IBM System i.

95 questions
0
votes
1 answer

Making RUNSQLSTM Display errors interactively

If I run the command RUNSQLSTM SRCFILE(ZIPPY19811/QSQLSRC) SRCMBR(JUSTIN) from the greenscreen, I get the status message RUNSQLSTM command failed. but to get the actual error message I have to do a WRKSPLF. Is there any way I could get the error…
Justin Dearing
  • 1,037
  • 12
  • 33
0
votes
1 answer

Create PASE home folder when creating a user profile

When you make a user profile on an IBM i, it does not create /home/USERNAME by default. When you first SSH in you have to make that folder. Is there a way to have that folder created on the IFS when you make a user profile?
Justin Dearing
  • 1,037
  • 12
  • 33
0
votes
1 answer

How to edit environment variable in PASE without VI or NANO etc

I'm new to IBMi but am relatively familiar with UNIX like OS's. I don't have VI or NANO in PASE on IBMi, I can't seem to download and install either of them either. I found EDTF here but when I use it, it's states command not found. Is there a…
d.lanza38
  • 357
  • 1
  • 6
  • 13
0
votes
1 answer

Apache won't start after upgrade to V6R1

Platform: OS/400 V6R1, IBM i After upgrade to V6R1, one of our Apache instances will not start. It appears to die silently; DSPJOBLOG yields nothing, /www//logs/error* are all empty, and a WRKSBSJOB QHTTPSVR command shows no leftover jobs or spool…
hewhocutsdown
  • 273
  • 4
  • 13
0
votes
1 answer

php_ibm_db2.dll on IIS 7.5 using PHP 5.3 error message

I'm trying to use ibm_db2 extension to access iSeries DB2 database. This is the testcode (taken from here)
grmbl
  • 155
  • 1
  • 9
0
votes
1 answer

Any Sample program in AS400 where we can redirect the output of a command to a file

We have a requirement for monitoring setup. Monitoring team says that if we can redirect the output of a command in AS400 to a logifle then they will be able to do the setup the monitoring alert. I am new to AS400. Could anyone please let us know if…
0
votes
1 answer

iSeries Apache SMTP error

I'm trying to send mail using either the built-in PHP mail() function or through the phpmailer library, which of course relies on mail(). phpmailer says it "cannot instantiate the mail function" so I'm troubleshooting directly through mail(). I do…
MaKR
  • 111
  • 6
0
votes
1 answer

IBM AS400/iSeries find which job is blocking a job queue

I'm working on an iSeries with system version 6.1. Some job is keeping other jobs in its queue to process. I know the queue name (PUR1) and see it has an abnormally amount of jobs in it. My understanding is that when a job runs, it moves from it…
0
votes
1 answer

Monitor Exchange Email Address and run scripts

Okay... Not sure how "out there" this thought is... Right now to send a pager message (aka text message), a user logs into our AS400... logs into the program... enters user name and message and hit's F10 to send. With a little looking, it seems…
WernerCD
  • 344
  • 2
  • 6
  • 18
0
votes
1 answer

How to hide a folder in the AS400 server?

I can list all folders(project folders) when i use shell commands in the as400 screen. I have accesss to this server and all project folders or directories are listed in my zend studio. But i cannot see one folder and its subdirectories. What will…
zod
  • 113
  • 5
0
votes
2 answers

AS400 Report Generation and File Location

I'm a bit rusty on my AS400-Fu... never really used it much honestly. I have a report (or 5) on a system that I have access too... how would I go about locating said report(s) and more detailed information about them. I'm not sure how the reports…
WernerCD
  • 344
  • 2
  • 6
  • 18
0
votes
1 answer

IBM AS400 ISeries Partitions

Can I have in one IBM ISeries partitions of HDD with diferent operating systems, example: 1 partition i5/os 2 partition AIX Regards, Pedro
Pedro
  • 667
  • 2
  • 9
  • 20
0
votes
1 answer

JDBC To DB2 for i is Slow when host server is Windows 2019 or 2022

This is a strange issue. I am trying to get a server upgraded from Windows Server 2016 Data Center to anything newer. We have tried 2019, and 2022. This server is an ETL server for running Talend Open Studio, it is a connection between MS Sql Server…
0
votes
1 answer

IBM i SSHD failing all authentications

I am trying to access the SSHD server on my IBMi. However I keep getting Permission denied (publickey,password,keyboard-interactive).. I am running v7r2 on my IBMi This was working until ran the commands to get yum installed on the partition. (Yum…
0
votes
1 answer

MySQL to MariaDB migration on IBM i connected to DB2 with IBMDB2I storage engine and RPG programs

we are in the process of migrating MySQL to MariaDB database on IBM i (AS400) server, but the problem is that MySQL DB has some databases connected to DB2 with DB2 storage engine so the migration will affect programs RPGs that need recompilation.…