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
1
vote
2
answers
319
views
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 ...
- 181
0
votes
1
answer
3k
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 ...
2
votes
1
answer
1k
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 ...
- 524
0
votes
1
answer
151
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
1
answer
192
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
1
vote
3
answers
431
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 ...
- 53
0
votes
1
answer
341
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 ...
- 101
0
votes
1
answer
2k
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 ...
- 236
2
votes
1
answer
923
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 ...
- 4,909
1
vote
2
answers
678
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 ...
- 4,909
2
votes
1
answer
1k
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), ...
- 131
0
votes
2
answers
1k
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 ...
- 53
4
votes
4
answers
394
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 ...
- 53
1
vote
1
answer
2k
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 ...
- 11
0
votes
2
answers
2k
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 ...
- 117
2
votes
1
answer
173
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 ...
- 123
-3
votes
1
answer
378
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 ...
- 101
6
votes
2
answers
488
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
1
answer
871
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.
- 16.9k
2
votes
2
answers
735
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 ...
- 21
2
votes
2
answers
236
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 ...
- 31
0
votes
1
answer
530
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 ...
- 133
2
votes
1
answer
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 ...
- 357
0
votes
2
answers
1k
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
1
answer
590
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 ...
- 1
-4
votes
1
answer
3k
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/...
- 1
0
votes
0
answers
76
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 ...
- 357
1
vote
1
answer
175
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....
- 357
0
votes
1
answer
363
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,037
1
vote
1
answer
74
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?
- 1,037
0
votes
1
answer
522
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 ...
- 1,037
0
votes
1
answer
114
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 ...
- 1,037
0
votes
1
answer
202
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 ...
- 357
4
votes
2
answers
2k
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 ...
- 91
1
vote
2
answers
492
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 ...
- 207
1
vote
1
answer
686
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,037
1
vote
0
answers
62
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]...
- 1,037
3
votes
1
answer
142
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,037
1
vote
0
answers
927
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
0
answers
122
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 ...
- 145
1
vote
1
answer
47
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 ...
- 113
1
vote
1
answer
479
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
1
answer
4k
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:
...
- 81
4
votes
4
answers
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 ...
- 143
1
vote
2
answers
628
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 ...
- 145
0
votes
1
answer
842
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 = '**********';
$...
- 155
8
votes
1
answer
1k
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 ...
- 165
0
votes
1
answer
2k
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
1
answer
387
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 ...
- 257
0
votes
1
answer
150
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'...
- 111