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.
95
questions
0
votes
1answer
56 views
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 ...
1
vote
0answers
89 views
Syslog-NG Error processing log message using IETF format
we've just changed our logging application on our AS/400 partitions and are now using a product called PowerTech SIEM agent for IBM I
The tool used to format messages using the old syslog convention ...
0
votes
1answer
47 views
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 ...
0
votes
1answer
33 views
How to send and use the V7R3 created program object in V7R2 version of iseries/AS400?
I have tried using save file with target system version *PRV/V7R2M0 but save file not saving the objects which are created with V7R3. How can i still use the V7R3 object in V7R2.
1
vote
3answers
107 views
Fastest reinstall of IBM i on AS/400
I have a iSeries that I am using for learning. Because it is for learning, I continually mess it up and end up having to reinstall the OS. This is a highly time consuming process, mainly because I ...
0
votes
1answer
133 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
1answer
481 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
210 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
216 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
538 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
476 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
157 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
703 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
748 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
125 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
320 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
370 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
70 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
498 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
196 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
343 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
760 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
302 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
74 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
78 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
258 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
56 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
318 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
65 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
114 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 ...
4
votes
2answers
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
356 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
490 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
54 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
123 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
751 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
91 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
40 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
355 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
3k 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
566 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
762 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
942 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
360 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
141 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'...
