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.
91
questions
0
votes
1answer
37 views
How to setup Single Sign On for IFS
Does anyone know how Windows/IBM i determines if Kerberos should be used when access an IFS folder via Windows File Explorer (e.g. \MYIBMI)? I've our IBM i EIM configured to do Single Sign On using ...
0
votes
0answers
15 views
ACS - Is it possible to auto switch from “Use Kerberos Authentication; do not prompt” to Prompt for User name and password
If the connection of my ACS 5250 client is configured to use "Use Kerberos Authentication; do not prompt" method to login to the IBM I, is there a way to tell it to switch it to prompt user for User ...
0
votes
1answer
153 views
IBM i 7.2, Admin-Port 2004 closed
On a fresh install of IBM i 7.2, with a regular IPL, the qhttpsvr subsystem is started and subsequently the admin-instance, which listens on TCP Port 2001. This port immediately redirects to Port 2004 ...
2
votes
1answer
73 views
What is a “session” on an iSeries / AS400?
I was asking another question here and they stated that I needed *REQUESTOR for the session I was running the command in. What is this session, and how do I find out what it is? I know about ...
1
vote
2answers
58 views
How does one watch another session on an AS/400?
I was working with a system admin yesterday and there was a vendor in an iSeries working, and he was able to observe the green screen as the vendor worked.
It was like VNC for iSeries; how does one ...
0
votes
1answer
312 views
ODBC Driver for IBM iSeries AS400 version V7R1
I am trying to connect to IBM iSeries using pyodbc, a Python interface for ODBC, on Linux Red Hat (Intel 64bit arch).
The following is what I have done:
Installed gcc-c++ (needed to compile pyodbc), ...
0
votes
2answers
214 views
iSeries recovery from SAVSYS media
I am trying to recover a AS/400 system (8203-E4A) using SAVSYS media (DAT 72 media / IBM i 7.1). However, when I attempt to IPL using the instructions provided on IBM's site, I get a code of B2004158 ...
4
votes
4answers
99 views
Linux on IBM iSeries 9406-520
I am looking to purchase an IBM iSeries 9406-520, and would like to run Linux on it without using OS/400. My understanding is that bare metal Linux is not possible on the iSeries (i.e. OS/400 must be ...
1
vote
1answer
424 views
How to edit physical file record on AS/400 by using STRSQL
I just got a new laptop with Windows 10 which can't use the "Data Transfer to iSeries" function in excel. I've tried to re-install the add-on again but still does not work.
I'd like to transfer file ...
0
votes
2answers
488 views
FTP to legacy IBM i with Filezilla
I want to FTP into IBM i (AS400) directly to "legacy file system".
Some sites talks about adding these lines to appropriate section.
<PostLoginCommands>
<Command>site namefmt ...
2
votes
1answer
111 views
as400 error code C100 101A
After a power failure while the IPL was being done in D mode, when I connect the server to the power again, the code C100101A appears in the panel, and after a while the server restarts and code ...
-3
votes
1answer
306 views
AS400 iseries with azure office365
I switched recently to a company after using SAP for years and I'm completely lost after having found that they are using AS400 still!.
I never used it before and I have three questions:
Is the ibm ...
6
votes
2answers
288 views
Is IBM's OS V7R2 the same as AIX?
Im working with a an iSeries Power 7+ server and the operating system is V7R2, is this a version of AIX or a completely different OS?
1
vote
1answer
41 views
AS400: How do you display which users have what rights on a particular library?
How do you display which users have what rights on a particular library? I want to display all user rights for a particular library.
2
votes
2answers
417 views
i5/OS PASE program not found or in use when CALLing QP2TERM
i5/OS PASE program not found or in use. Path name is
/QOpenSys/usr/bin/sleep.
I am getting this error on a system that had the PASE software installed recently. I need ...
2
votes
2answers
158 views
LTO 5 duplication to an LTO 3
I want to upgrade my virtual drives and virtual tapes to LTO5.
My physical drives and tapes are LTO3. Will I still be able to run a DUPTAP and copy my information from the virtual LTO5 drive to the ...
0
votes
1answer
289 views
Confused about database names and remote locations on AS400
I'm taked with buildig a web service that gets it's data from an old AS400 database server.
I'm trying to connect over nodejs using https://github.com/ibmdb/node-ibm_db and i'm getting this error on ...
1
vote
1answer
2k views
Block web requests based on a portion of the user agent string - Not working
I'm trying to block web requests based on if they contain any of a group of strings. As far as I can tell between my own knowledge and searching online, what I have is correct. However, I'm still ...
0
votes
2answers
577 views
ibm i series / as400 ip policies / firewall rules
I have an IBM I series (AS/400) that needs to go onto a public ip. I would like to shut the internet facing ports down and only open some ports to the outside world and keep the internal network open ...
0
votes
1answer
247 views
what is alternative for SITE command of ftp in sftp
I am trying to connect to a mainframe from linux server using sftp command and execute a SITE command and transfer file to mainframe, but it is failing and showing Invalid command.
I am using batch ...
-4
votes
1answer
2k views
I can not start HTTP server Admin on AS400
The error message is...
CPF9898 Escape 40 19/03/16 11:11:55.552230 QLWISVRA QSYS *STMT QLWIIHSMOD QHTTPSVR *STMT
From module . . . . . . . . : QLWIMSG 5761SS1 V6R1M0 080215 Job Log MLCNAS05 19/...
0
votes
0answers
73 views
Web Server Log analyzer from a security perspective
Web Server Log analyzers are really meant to just show trends, statistics and are more geared towards an SEO/Marketing standpoint. How can I do the following in regards to HTTP(s) traffic from a ...
1
vote
1answer
57 views
IBMi and the Digital Certificate Manager with Multi-Domain SSL Certs
My company recently purchased a Multi-Domain SSL certificate for use on an IBMi V7R2. I'm relatively new to the IBMi world, but I get the feeling the DSM doesn't support Multi-Domain SSL certificates....
0
votes
1answer
217 views
Where do pear packages get installed on the IBM i?
I have a V7R1 system with zend zerver and pear seems to work:
$ /usr/local/zendsvr6/bin/pear channel-discover pear.phing.info
Adding Channel "pear.phing.info" succeeded
Discovery of channel "pear....
1
vote
1answer
54 views
Is there a whereis command equivalent on PASE?
The whereis command lets me find the location of a command that is on my path on linux, amongst other things. Is there an equivalent on PASE? If so, do I need a PTF?
0
votes
1answer
266 views
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 ...
0
votes
1answer
64 views
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 ...
0
votes
1answer
99 views
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 ...
3
votes
1answer
1k views
CORS headers not added in Apache
I've been working on this issue for days. I'm a developer and my knowledge of these things is very limited, still there's no one available in this company to assist me with this issue. This really has ...
1
vote
2answers
310 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
444 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
52 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 PASSWORD]...
3
votes
1answer
108 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
722 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 ...
4
votes
0answers
86 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 ...
1
vote
1answer
39 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
343 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
2k 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
1k views
Example pyodbc db2 connection [closed]
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
5k 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
551 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
677 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
892 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
1k 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
340 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
132 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 I'...
1
vote
1answer
339 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:
./...
1
vote
2answers
2k 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
696 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
372 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. ...
