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

learn more… | top users | synonyms (2)

1
vote
2answers
24 views

IBM i (OS/400) and ephemeral ports

We have a custom application in house, where a large pool of Windows clients is accessing an imaging service on IBM i (AS/400) running V5R4. Occasionally, under heavy CPU load, the clients are unable ...
1
vote
1answer
22 views

Running SQL queriesfrom PASE instead of QSH

If I ssh into my IBMi, and start qsh, I can run db2 -S "SELECT * FROM LIB.SOMEPF" and get the results. I cannot do it from the default PASE screen. I get $ /usr/bin/db2 /usr/bin/db2: cannot execute ...
1
vote
0answers
24 views

db2 -S is hanging on IBMi

I can ssh into my IBMi and start qsh. If I type db2 with no parameters I get the standard help message: db2 USAGE: CMD [-v] [-S] [-s] [-t | -T<char> | -d] [-r RDBNAME [-u USERNAME -p ...
3
votes
1answer
29 views

Editing the PATH in PASE

I am doing a some PHP development on an IBMi running ZendServer6. I have to call PHP by its full path of /usr/local/zendsvr6/bin/php-cli. Is there a dotfile I can edit in my home directory or some ...
1
vote
0answers
44 views

iSeries network shares not working with new computer

I was able to access network shares on our iSeries server until I received a new computer. When I try to navigate to \server-name\share I am repeatedly prompted for my username or I will receive the ...
3
votes
0answers
33 views

Data location of IBM i Apache server descriptions in HTTPAdmin interface

I'm working on replicating Apache servers to a HA box, and I can replicate the servers themselves correctly (QUSRSYS/QATMHINSTC and the associated files in /www/), but I cannot find where the ...
0
votes
0answers
29 views

Apache Flume on IBM iSeries

I am new to Flume. My organization uses iSeries (AS400) as its core platform and is currently on version V7R1M0. I intend to capture our server logs for further analysis regarding performance related ...
1
vote
1answer
21 views

ftp alter server response in transit

I have a unique situation where one of my business partners runs a FTP server that is out of date and the client I need to use is slightly incompatible. The server I'm connecting to returns a 334 ...
1
vote
1answer
119 views

Change AS400 IP Address from Remote Session

We need to change the IP address of our as400 this weekend. I've found instructions to remove the routes associated with the interface, etc. However, our terminal that is physically connected to the ...
7
votes
1answer
644 views

Is there a way for iSeries AS400 sessions not get disconnected or locked

I have to deal with this in a daily basis: For some reason, maybe due to input error, our users get their sessions disconnected from our iSeries AS400 and I have to manually enter the command: ...
1
vote
0answers
221 views

Example pyodbc db2 connection

I am trying to get a pyodbc connection (on a Centos machine), to a DB2 database running on an IBM i. Whatever connection string or configuration I add, I always get the same message .. Traceback ...
4
votes
4answers
2k views

Telnet connection to an AS400 system via telnetlib (Python)

I use telnetlib - Python - to create a telnet client - port 23 - to communicate with an AS/400 server. communication with the telnet command that is no problem, but with telnetlib I do not get any ...
1
vote
2answers
170 views

Simulating AS400 iSeries for ADO.NET

I' have to write an import procedure in c# for a customer. The procedure needs to read data from an AS400 iSeries, so my first Question is: what's "better" (pro/cons) between direct connection (using ...
0
votes
1answer
280 views

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) <?php $database = 'ALI452BFAL'; //library $user = 'STN452'; $password = '**********'; ...
8
votes
1answer
146 views

IBM System i Permissions on Database views

We have an IBM System i running IBM i OS v6r1. On this system, I have created some database views. What I want to do is give a particular user group access to ONLY these views and nothing else ...
0
votes
1answer
296 views

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 ...
3
votes
1answer
160 views

SNMP to read tape status on AS/400?

I have a 3580 on an AS/400 and want to monitor tape status, most importantly, is one actually inserted, using SNMP get. Find a lot of SNMP details on tape libraries, but for a stand alone drive I ...
0
votes
1answer
96 views

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 ...
1
vote
1answer
201 views

Error compiling GhostPDL for PASE (AIX) on OS/400 V5R4

I'm trying to compile ghostpdl 9.07 on V5R4 in QP2TERM (the AIX-like PASE environment). After downloading and untarring the package to /QOpenSys, I ran: CALL QP2TERM and then in QP2TERM: ...
0
votes
2answers
621 views

the job exceeded end severity (ENDSEV job attribute)

one of our clients recently purchased a new printer. This printer is a slightly different model from what it is replacing, however is only an upgraded model (T640 to T644) - The printer can be pinged ...
1
vote
0answers
298 views

How do I install linux ODBC driver for IBM iSeries?

Been following instructions here: http://www-03.ibm.com/systems/power/software/i/access/linux/guide.html Trying to install in CentOS instance after installing unixODBC. Installed all dependencies ...
1
vote
0answers
208 views

LAMP using ODBC to DB2

I have connected an openSUSE LAMP and an Ubuntu LAMP server to DB2 using ODBC. The openSUSE system we're using for a development environment, and the final deployment is to be on the Ubuntu system. ...
5
votes
1answer
1k views

iis 7 application pools not starting after installing ibm client access

I have a windows 2008 dev/testing server setup for testing web apps. I just installed ibm client access (v6r1m0) and after my reboot my sites now get a 503 service unavailable error. My application ...
2
votes
1answer
124 views

Issue With Case Sensitivity on IBM Power server queries

Where I work, we have an IBM Power System that we use for data storage and access. It is currently running i OS 6.1. We have a website on an IIS server that pulls data from this server and has ...
5
votes
1answer
1k views

How to know available disk space in AS400 tape?

I tried the DSPTAP command but it only shows the size of the objects saved, there is no indication on how much space is still available.
2
votes
1answer
86 views

IBMi bash upgrade

I am trying to install rvm in PASE on IBMi (v7.1) but it is failing because it states bash version 3.2.25 is required. Running bash --version via CALL QP2TERM states I am running the following ...
0
votes
1answer
374 views

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 ...
4
votes
2answers
807 views

Using SFTP on AS400 Non Linux Based OS

I am trying to establish an SFTP connection on an AS400, which is on an OS that is not running a Linux based kernel. Any idea where I can start with this?
1
vote
0answers
39 views

runas or sudo equivalent on AS400 ibm iSeries (invoke it via java code) [duplicate]

Possible Duplicate: “runas” or “sudo” equivalent on AS400 IBM iSeries I am trying to invoke a program to run as another user(by getting input user/pwd) in AS400 OS ...
5
votes
1answer
674 views

“runas” or “sudo” equivalent on AS400 IBM iSeries

I'm trying to invoke a program to run as another user (by getting input user/pwd) in AS400 OS using Java. Like runas in Windows or sudo in Unix — what can we do in AS400 OS? I am able to invoke basic ...
5
votes
3answers
491 views

Why is it especially bad to reboot a mainframe? [closed]

This is something I've heard a lot throughout my career, from practically every mainframe operator/admin I've ever worked with, and up until now, I never really questioned it, or had a reason to care ...
2
votes
1answer
185 views

How to connect InfoWindow II to IBM 9406-250?

I received an old InfoWindow II (don't know the exact model number yet) from somebody, and want to connect it as a console for my IBM 9406-250 so I can do a manual IPL. I am totally new to this, and ...
3
votes
1answer
425 views

QSECOFR password reset

I just bought a second hand IBM iSeries 9406-250 for educational use, but I can't find the QSECOFR password. Which ways are available to recover it if you don't have any details, except the device ...
-1
votes
1answer
381 views

Which client to use for AS400 terminal? [closed]

I would like to connect to AS400 machine but I do not know which client to use. I have clients installed at work but I do not remember how it is called. I use Windows 7. Can anyone help me ?
4
votes
1answer
45 views

OS400/Pase restoring to scratch

Simple question, is there any way to restore Pase so that for example QOpenSys/ restores all files back to scratch ?
3
votes
1answer
276 views

How do I set up Tomcat with SSL on the iSeries?

OS/400 is V5R4, Java 1.6 is installed on the system, and we're using Tomcat 5.5, but we're having difficulty getting Tomcat working using HTTPS. We created a self-signed certificate and uncommented ...
1
vote
1answer
333 views

Disrupted transfer from AS400 to pure-ftpd on Ubuntu

We have an FTP job that runs between an AS400 and pure-ftpd on Ubuntu that's worked for two years. The AS400 (in a remote shop) sends three files. Recently, it only gets the first of the three done, ...
4
votes
2answers
281 views

iSeries survival guide for a Unix/Windows techie

I'm a developer working mostly on a Java application which interfaces with an iSeries back end (the iSeries is running OS 6.1). I consider myself to be reasonably strong on DBA and sysadmin topics ...
1
vote
3answers
138 views

Free Version of linux for iseries power5

At work we have an old iseries server and we want to install Linux on it. On the IBM website they says that Redhat Enterprise and SUSE Enterprise Server are supported, however, both of these cost ...
1
vote
1answer
406 views

Accessing the QSYSOPR message from the DB2 iSeries console when it is locked

For a variety of reasons yesterday we had to shut off access to the router that our iSeries connects to, we did this in an attempt to prevent a full shut down of the iSeries. Today when we ...
5
votes
1answer
246 views

Connecting to AS/400 hardware

In about 2-3 weeks I'm getting an old AS/400 server (something 9406, probably 6xx or 8xx) to learn OS/400 from administrators point of view. Will I need some special hardware to connect and do IPL ...
2
votes
4answers
3k views

iSeries DB2 - SQL GUI Tool

Can someone suggest a good free Database tool with SQL support for connection to an iSeries. Currently I am using the green screen and it is quite frustrating.
5
votes
3answers
496 views

Capabilities of AS400 FTP Client

I have a customer who is attempting to send data to my company via FTP, from an AS400. The customer maintains that all usernames and passwords are converted to upper-case by the AS400 FTP client. This ...
0
votes
1answer
210 views

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 ...
1
vote
2answers
309 views

AS400 and Remote Commands

On the AS400 I want to remotely execute: strpgrprg topgr(userx) message(ALERT!) What options are available to me? update: I want to run a AS400 program from outside of the AS400. I want to ...
1
vote
2answers
7k views

Where can I get the AS/400 Client Access Express for Windows software?

Where can I get "AS/400 Client Access Express for Windows"? Is this free (in terms of money) software and where can I download it? I couldn't find any workable download link. Thank you very much for ...
0
votes
1answer
302 views

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 ...
1
vote
1answer
762 views

How can I connect to AS/400 through TN5250?

How will I find out my iseries server name? I checked through "nslookup" it gives one ip address & I tried to connect TN5250 session to cconnect but could not connect. from dos command line ...
1
vote
2answers
3k views

AS/400 error message - Cannot allocate device

When I display tape or initialize a tape using DSPTAP or INZTAP commands and enter the parameters I get the error message "Cannot allocate device tap01..." Please help me as I am new to AS/400.
5
votes
2answers
2k views

AS400 Backup Inquiry?

Can someone tell me the commands to view the status or logs of our backup jobs that are running on our AS400? Our sysadmin decided to walk out last week and I would like to check on these jobs to ...