473,657 Members | 2,566 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

DB2/zOS: Recreate DBRMs from remote bounded packages

Hallo,

I need to recreate (lost) DBRM-sources from packages
to BIND them on another DB2 system
which is not accessible via DDF (for remote BIND).

I've written a REXX program to recreate DBRM-sources from the data in
SYSIBM.SYSPACKS TMT: reblock to FB(80) and some additional
informationen: 'DBRM'||X(16+LE NGTH(Stmt))+X(S ECTNO)+X(0)+X(Q UERYNO)+X(20)+S UBSTR(Stmt,5).

It works fine for DBRMs bound from a DBRMLIB ( BIND PACKAGE/PLAN ...
LIBRARY() MEMBER() ... ) but not for remote bound packages.

Does anybody has an idea how to do or where to find information
between the differences in SYSIBM.SYSPACKS TMT between local and remote
bound packages?

So long, Rudi
Nov 12 '05 #1
0 1470

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
4274
by: Carmine | last post by:
I need to import a huge .ixf file from a pc to db2 v7 zos. Is there a way to stop archive logging while the data is being imported? If not, is it safe to delete archive logs that haven't expired? Thanks.
1
3102
by: Prem K Mehrotra | last post by:
Is there a way to see current settings of DSNZPARM using trace or some other command. If yes, what exactly is the command. I come from Oracle background. In Oracle there is show parameter all command which can show all the parameters. I am looking something similar Prem
4
4262
by: Mark | last post by:
I am running DB2 V8.1 ESE client running on Windows XP Professional configured to connect directly to DB2 V6.1.2 on OS/390. I can connect to the OS/390 DB2 database (DB2 subsystem). But when I try to issue a select, I get an error message saying: "DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0805N Package...
6
2166
by: bikkaran | last post by:
how to create a exact replica of a database. I have a database . There must be some structure of it. I want to recreate the same structure of the database on some another new server . Please help me. best regards bikash
1
1502
by: geoff | last post by:
Hi All, I am accessing db2 for zOS from a windows xp client and trying to find out how many times a select or update sql statement is executed. I am able to do this easily in db2 for windoze by by bringing up the monitor and generating a pre-defined report. I can also do it thru sql directly by using a snapshot function. However, none of this works on zOS db2. The only thing that works is a
3
3023
by: geoff | last post by:
I have a table called 'employee' with one column called 'name', a varchar. If I execute the following insert statements: insert into employee(name) values ('jones') insert into employee(name) values ('smith') insert into employee(name) values ('billy-bob') .. . . they work, no problem. If I execute the following: insert into employee(name) values ('jones'),('smith'),('billy-bob')
2
4549
by: pratcp | last post by:
I have a remote server (a shared hosting webserver) where I have few users ftp some flat files. I need to access these files using a windows app/windows service written using c# and run it on a nightly basis. How do I access the remote server in a c# windows service or console app? The reason I need remote access is that I cannot have any type of schedule jobs running on a shared hosting webserver. I was contemplating on using SSIS sql...
3
8667
by: karanbikash | last post by:
Hi , I would like to know : 1.how to find all the schema in my DB2 database on Main frame machine . 2. How to see all the tables for a given schema . 3. What are the default schema in Db2 on Mainframe . zOS. I know all the above when I connect to DB2 on LUW ..
5
1980
by: agarwasa2008 | last post by:
Hi, I have a linked table called tbltest and some bounded forms (which add, update, delete records) that were created using that linked table. For some necessary reasons I had to create another linked table called tblComponents and then I bounded the original forms to this new table. I did change the control source: Description (Field name) RowSource Type: Table/Query (which remains the same)
0
8827
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8732
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8503
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8605
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7333
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5632
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4158
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
2731
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1957
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.