Regarding Replication DB2 UDB

sat

i have seen the check status then it is showing like :

Type Of Thread Status
HoldL Resting
Admin Thread Resting
Worker Thread Resting

So now how can i activate them again?

Knut Stolze wrote:

sat wrote:

Hi!
I have seen jus now in the target table (TGDEPTCOPY) it's still
showing only 4 records.I kept the time interval for replication as 15
minutes.But still its not working.I'm not even facing any errors.Please
do let me know what might be the problem.

Hard to tell. Did you use the logs when you started capture and apply?
Have you actually started both? What do the logs show? What does
the "status" in the Replication Center show?

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Sep 19 '06 #1

Subscribe Reply

3450

Knut Stolze

sat wrote:

i have seen the check status then it is showing like :

Type Of Thread Status
HoldL Resting
Admin Thread Resting
Worker Thread Resting

So now how can i activate them again?

Is that the status of capture or apply? Have you started both? What was
the message you got upon starting of each?

How about the logs - which entries do you find there? Did you use the logs
when you started capture and apply?

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Sep 19 '06 #2

sat

The status below is for apply and first itself i have started both the
capture and apply programs.And then what i did is like while defining
the subscription set in the ROW FILTER i have given only ENO which are

>= E00 should be applied.And after that i inserted 2 records which are E22 , E23 and recently ( means today morning) i added one more row E25...but they are not being copied.

Knut Stolze wrote:

sat wrote:

i have seen the check status then it is showing like :

Type Of Thread Status
HoldL Resting
Admin Thread Resting
Worker Thread Resting

So now how can i activate them again?

Is that the status of capture or apply? Have you started both? What was
the message you got upon starting of each?

How about the logs - which entries do you find there? Did you use the logs
when you started capture and apply?

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Sep 19 '06 #3

Knut Stolze

sat wrote:

The status below is for apply and first itself i have started both the
capture and apply programs.And then what i did is like while defining
the subscription set in the ROW FILTER i have given only ENO which are
= E00 should be applied.And after that i inserted 2 records which are E22
, E23 and recently ( means today morning) i added one more row E25...but
they are not being copied.

Again, what do you see in the logs?

Since you are using row filter, what happens if you omit the filter?

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Sep 19 '06 #4

sat

If i omit the row filter then by default all the rows will be
copied.Now as i have given only ENO's >= E00 will be copied.Hope i'm
right.

i didnt get the Question what u're trying to ask about logs.
If u can please elaborate the Question and let me know.

Knut Stolze wrote:

sat wrote:

The status below is for apply and first itself i have started both the
capture and apply programs.And then what i did is like while defining
the subscription set in the ROW FILTER i have given only ENO which are
>= E00 should be applied.And after that i inserted 2 records which are E22
, E23 and recently ( means today morning) i added one more row E25...but
they are not being copied.

Again, what do you see in the logs?

Since you are using row filter, what happens if you omit the filter?

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Sep 19 '06 #5

sat

2006-09-15-21.08.10.031000 <CPREST(01/00)ASN1044I APPLY "DEPTQUAL" :
"WorkerThre ad". The Apply program will become inactive for "1" minutes
and "0" seconds.
2006-09-15-21.09.10.421000 <CPREST(01/00)ASN1044I APPLY "DEPTQUAL" :
"WorkerThre ad". The Apply program will become inactive for "0" minutes
and "59" seconds.
2006-09-15-21.10.09.718000 <CPREST(01/00)ASN1044I APPLY "DEPTQUAL" :
"WorkerThre ad". The Apply program will become inactive for "1" minutes
and "0" seconds.

2006-09-16-15.00.19.062000 <asnThread::sto pASN8045D "Apply" :
"DEPTQUAL" : "Initial" : Thread "Initial" received return code "2011"
from exiting thread "HoldLThrea d".

2006-09-16-15.00.19.281000 <queryDB2Status ASN0552E "Apply" :
"DEPTQUAL" : "Initial" : The program encountered an SQL error. The
server name is "COPYDB". The SQL request is "sqlmonss". The table name
is "N/A". The SQLCODE is "-30082". The SQLSTATE is "08001". The
SQLERRMC is "24ÿUSERNAM E AND/OR PASSWORD INVALIDÿ". The SQLERRP is
"SQLEXPLG".

2006-09-16-15.00.19.281000 SQL30082 "Apply" : "DEPTQUAL" : "Initial" :
Attempt to establish connection failed with security reason "24"

("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001
2006-09-16-15.00.19.281000 <Asnenv:delEnvI pcQRcvHdlASN800 8D "Apply"
: "DEPTQUAL" : "Initial" : "Destroyed" IPC queue with key(s)
"(OSSEIPC48temp DB2.COPYDB.DEPT QUAL.APP.IPC,
OSSEIPC49tempDB 2.COPYDB.DEPTQU AL.APP.IPC,
OSSEIPC50tempDB 2.COPYDB.DEPTQU AL.APP.IPC)".

2006-09-16-15.00.19.281000 <_asnApplyASN10 97I APPLY "DEPTQUAL" :
"Initial". The Apply program stopped.

2006-09-16-15.00.19.328000 <disconnectDB2D istributedASN05 52E "Apply"
: "DEPTQUAL" : "Initial" : The program encountered an SQL error. The
server name is "COPYDB". The SQL request is "DISCONNECT ". The table
name is "N/A". The SQLCODE is "-1024". The SQLSTATE is "08003". The
SQLERRMC is "". The SQLERRP is "SQLACALL".

2006-09-19-15.13.29.531000 <asnThread::sto pASN8045D "Apply" :
"DEPTQUAL" : "Initial" : Thread "Initial" received return code "2011"
from exiting thread "HoldLThrea d".

2006-09-19-15.13.29.531000 <asnThread::sto pASN8045D "Apply" :
"DEPTQUAL" : "Initial" : Thread "Initial" received return code "2011"
from exiting thread "AdminThrea d".

2006-09-19-15.13.29.531000 <queryDB2Status ASN0552E "Apply" :
"DEPTQUAL" : "Initial" : The program encountered an SQL error. The
server name is "COPYDB". The SQL request is "sqlmonss". The table name
is "N/A". The SQLCODE is "-30082". The SQLSTATE is "08001". The
SQLERRMC is "24ÿUSERNAM E AND/OR PASSWORD INVALIDÿ". The SQLERRP is
"SQLEXPLG".
These were some of the errors i have see.....

sat wrote:

If i omit the row filter then by default all the rows will be
copied.Now as i have given only ENO's >= E00 will be copied.Hope i'm
right.

i didnt get the Question what u're trying to ask about logs.
If u can please elaborate the Question and let me know.

Knut Stolze wrote:
sat wrote:

The status below is for apply and first itself i have started both the
capture and apply programs.And then what i did is like while defining
the subscription set in the ROW FILTER i have given only ENO which are
= E00 should be applied.And after that i inserted 2 records which are E22
, E23 and recently ( means today morning) i added one more row E25....but
they are not being copied.
Again, what do you see in the logs?

Since you are using row filter, what happens if you omit the filter?

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Sep 19 '06 #6

sat

Can u please tell me what i need to do if i want to bring the the
status of the capture program from the resting status to the active
state.And just now i have observed that its showint like the status as
PRESUMED DOWN for apply program.
So, please guide me regarding this.

sat wrote:

2006-09-15-21.08.10.031000 <CPREST(01/00)ASN1044I APPLY "DEPTQUAL" :
"WorkerThre ad". The Apply program will become inactive for "1" minutes
and "0" seconds.
2006-09-15-21.09.10.421000 <CPREST(01/00)ASN1044I APPLY "DEPTQUAL" :
"WorkerThre ad". The Apply program will become inactive for "0" minutes
and "59" seconds.
2006-09-15-21.10.09.718000 <CPREST(01/00)ASN1044I APPLY "DEPTQUAL" :
"WorkerThre ad". The Apply program will become inactive for "1" minutes
and "0" seconds.

2006-09-16-15.00.19.062000 <asnThread::sto pASN8045D "Apply" :
"DEPTQUAL" : "Initial" : Thread "Initial" received return code "2011"
from exiting thread "HoldLThrea d".

2006-09-16-15.00.19.281000 <queryDB2Status ASN0552E "Apply" :
"DEPTQUAL" : "Initial" : The program encountered an SQL error. The
server name is "COPYDB". The SQL request is "sqlmonss". The table name
is "N/A". The SQLCODE is "-30082". The SQLSTATE is "08001". The
SQLERRMC is "24ÿUSERNAM E AND/OR PASSWORD INVALIDÿ". The SQLERRP is
"SQLEXPLG".

2006-09-16-15.00.19.281000 SQL30082 "Apply" : "DEPTQUAL" : "Initial" :
Attempt to establish connection failed with security reason "24"

("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001
2006-09-16-15.00.19.281000 <Asnenv:delEnvI pcQRcvHdlASN800 8D "Apply"
: "DEPTQUAL" : "Initial" : "Destroyed" IPC queue with key(s)
"(OSSEIPC48temp DB2.COPYDB.DEPT QUAL.APP.IPC,
OSSEIPC49tempDB 2.COPYDB.DEPTQU AL.APP.IPC,
OSSEIPC50tempDB 2.COPYDB.DEPTQU AL.APP.IPC)".

2006-09-16-15.00.19.281000 <_asnApplyASN10 97I APPLY "DEPTQUAL" :
"Initial". The Apply program stopped.

2006-09-16-15.00.19.328000 <disconnectDB2D istributedASN05 52E "Apply"
: "DEPTQUAL" : "Initial" : The program encountered an SQL error. The
server name is "COPYDB". The SQL request is "DISCONNECT ". The table
name is "N/A". The SQLCODE is "-1024". The SQLSTATE is "08003". The
SQLERRMC is "". The SQLERRP is "SQLACALL".

2006-09-19-15.13.29.531000 <asnThread::sto pASN8045D "Apply" :
"DEPTQUAL" : "Initial" : Thread "Initial" received return code "2011"
from exiting thread "HoldLThrea d".

2006-09-19-15.13.29.531000 <asnThread::sto pASN8045D "Apply" :
"DEPTQUAL" : "Initial" : Thread "Initial" received return code "2011"
from exiting thread "AdminThrea d".

2006-09-19-15.13.29.531000 <queryDB2Status ASN0552E "Apply" :
"DEPTQUAL" : "Initial" : The program encountered an SQL error. The
server name is "COPYDB". The SQL request is "sqlmonss". The table name
is "N/A". The SQLCODE is "-30082". The SQLSTATE is "08001". The
SQLERRMC is "24ÿUSERNAM E AND/OR PASSWORD INVALIDÿ". The SQLERRP is
"SQLEXPLG".
These were some of the errors i have see.....

sat wrote:
If i omit the row filter then by default all the rows will be
copied.Now as i have given only ENO's >= E00 will be copied.Hope i'm
right.

i didnt get the Question what u're trying to ask about logs.
If u can please elaborate the Question and let me know.

Knut Stolze wrote:
sat wrote:
>
The status below is for apply and first itself i have started both the
capture and apply programs.And then what i did is like while defining
the subscription set in the ROW FILTER i have given only ENO which are
>= E00 should be applied.And after that i inserted 2 records which are E22
, E23 and recently ( means today morning) i added one more row E25....but
they are not being copied.
>
Again, what do you see in the logs?
>
Since you are using row filter, what happens if you omit the filter?
>
--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Sep 19 '06 #7

Knut Stolze

sat wrote:

Can u please tell me what i need to do if i want to bring the the
status of the capture program from the resting status to the active
state.

Is the "Resting" the status of Apply or Capture? Here you talk about
Capture, but in the other posting you said it's the Apply status.

And just now i have observed that its showint like the status as
PRESUMED DOWN for apply program.
So, please guide me regarding this.

I'm pretty sure that it comes down to figuring out what causes the error
messages below and then fixing those problems.

sat wrote:
>2006-09-15-21.08.10.031000 <CPREST(01/00)ASN1044I APPLY "DEPTQUAL" :
"WorkerThread" . The Apply program will become inactive for "1" minutes
and "0" seconds.
2006-09-15-21.09.10.421000 <CPREST(01/00)ASN1044I APPLY "DEPTQUAL" :
"WorkerThread" . The Apply program will become inactive for "0" minutes
and "59" seconds.
2006-09-15-21.10.09.718000 <CPREST(01/00)ASN1044I APPLY "DEPTQUAL" :
"WorkerThread" . The Apply program will become inactive for "1" minutes
and "0" seconds.

2006-09-16-15.00.19.062000 <asnThread::sto pASN8045D "Apply" :
"DEPTQUAL" : "Initial" : Thread "Initial" received return code "2011"
from exiting thread "HoldLThrea d".

2006-09-16-15.00.19.281000 <queryDB2Status ASN0552E "Apply" :
"DEPTQUAL" : "Initial" : The program encountered an SQL error. The
server name is "COPYDB". The SQL request is "sqlmonss". The table name
is "N/A". The SQLCODE is "-30082". The SQLSTATE is "08001". The
SQLERRMC is "24Ã¿USERNA ME AND/OR PASSWORD INVALIDÃ¿". The SQLERRP is
"SQLEXPLG".

Check the user/password settings that you use in the Control Center
(or "asnclp" if you manage DB2 Replication that way). I'd think that you
have somewhere a non-existing user or an invalid password specified, which
causes the SQL30082 to be raised. Also, make sure that the user under
whose authority capture/apply is run is allowed to connect to both
databases.

>2006-09-16-15.00.19.281000 <Asnenv:delEnvI pcQRcvHdlASN800 8D "Apply"
: "DEPTQUAL" : "Initial" : "Destroyed" IPC queue with key(s)
"(OSSEIPC48tem pDB2.COPYDB.DEP TQUAL.APP.IPC,
OSSEIPC49tempD B2.COPYDB.DEPTQ UAL.APP.IPC,
OSSEIPC50tempD B2.COPYDB.DEPTQ UAL.APP.IPC)".

2006-09-16-15.00.19.281000 <_asnApplyASN10 97I APPLY "DEPTQUAL" :
"Initial". The Apply program stopped.

2006-09-16-15.00.19.328000 <disconnectDB2D istributedASN05 52E "Apply"
: "DEPTQUAL" : "Initial" : The program encountered an SQL error. The
server name is "COPYDB". The SQL request is "DISCONNECT ". The table
name is "N/A". The SQLCODE is "-1024". The SQLSTATE is "08003". The
SQLERRMC is "". The SQLERRP is "SQLACALL".

That appears to be a follow-up for the above error. Apply can't connect to
the "COPYDB" (because of invalid credentials) and then shuts down. The
DISCONNECT fails with SQL1024 because the preceeding connect never worked.
So that's actually ok.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Sep 19 '06 #8

sat

Actually for both the capture and apply programs the check status is in
resting.
So how can i activate them again?
So that the replication will work fine?Worker thread,Admin thread...
all these are the ones which i have seen in check status.
So, please guide me how i need to activate both the programs.

Knut Stolze wrote:

sat wrote:

Can u please tell me what i need to do if i want to bring the the
status of the capture program from the resting status to the active
state.

Is the "Resting" the status of Apply or Capture? Here you talk about
Capture, but in the other posting you said it's the Apply status.

And just now i have observed that its showint like the status as
PRESUMED DOWN for apply program.
So, please guide me regarding this.

I'm pretty sure that it comes down to figuring out what causes the error
messages below and then fixing those problems.

sat wrote:
2006-09-15-21.08.10.031000 <CPREST(01/00)ASN1044I APPLY "DEPTQUAL" :
"WorkerThre ad". The Apply program will become inactive for "1" minutes
and "0" seconds.
2006-09-15-21.09.10.421000 <CPREST(01/00)ASN1044I APPLY "DEPTQUAL" :
"WorkerThre ad". The Apply program will become inactive for "0" minutes
and "59" seconds.
2006-09-15-21.10.09.718000 <CPREST(01/00)ASN1044I APPLY "DEPTQUAL" :
"WorkerThre ad". The Apply program will become inactive for "1" minutes
and "0" seconds.

2006-09-16-15.00.19.062000 <asnThread::sto pASN8045D "Apply" :
"DEPTQUAL" : "Initial" : Thread "Initial" received return code "2011"
from exiting thread "HoldLThrea d".

2006-09-16-15.00.19.281000 <queryDB2Status ASN0552E "Apply" :
"DEPTQUAL" : "Initial" : The program encountered an SQL error. The
server name is "COPYDB". The SQL request is "sqlmonss". The table name
is "N/A". The SQLCODE is "-30082". The SQLSTATE is "08001". The
SQLERRMC is "24ÿUSERNAM E AND/OR PASSWORD INVALIDÿ". The SQLERRP is
"SQLEXPLG".

Check the user/password settings that you use in the Control Center
(or "asnclp" if you manage DB2 Replication that way). I'd think that you
have somewhere a non-existing user or an invalid password specified, which
causes the SQL30082 to be raised. Also, make sure that the user under
whose authority capture/apply is run is allowed to connect to both
databases.

2006-09-16-15.00.19.281000 <Asnenv:delEnvI pcQRcvHdlASN800 8D "Apply"
: "DEPTQUAL" : "Initial" : "Destroyed" IPC queue with key(s)
"(OSSEIPC48temp DB2.COPYDB.DEPT QUAL.APP.IPC,
OSSEIPC49tempDB 2.COPYDB.DEPTQU AL.APP.IPC,
OSSEIPC50tempDB 2.COPYDB.DEPTQU AL.APP.IPC)".

2006-09-16-15.00.19.281000 <_asnApplyASN10 97I APPLY "DEPTQUAL" :
"Initial". The Apply program stopped.

2006-09-16-15.00.19.328000 <disconnectDB2D istributedASN05 52E "Apply"
: "DEPTQUAL" : "Initial" : The program encountered an SQL error. The
server name is "COPYDB". The SQL request is "DISCONNECT ". The table
name is "N/A". The SQLCODE is "-1024". The SQLSTATE is "08003". The
SQLERRMC is "". The SQLERRP is "SQLACALL".

That appears to be a follow-up for the above error. Apply can't connect to
the "COPYDB" (because of invalid credentials) and then shuts down. The
DISCONNECT fails with SQL1024 because the preceeding connect never worked.
So that's actually ok.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Sep 20 '06 #9

Knut Stolze

sat wrote:

Actually for both the capture and apply programs the check status is in
resting.
So how can i activate them again?
So that the replication will work fine?Worker thread,Admin thread...
all these are the ones which i have seen in check status.
So, please guide me how i need to activate both the programs.

I'm sorry, but I don't see any point in continuing this discussion since you
don't appear to read my responses.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Sep 20 '06 #10

Similar topics

3887

Setting up replication with access front end

by: John | last post by:

Hi We have an access app (front-end+backend) running on the company network. I am trying to setup replication for laptop users who go into field and need the data synched between their laptops and the server upon return to the office. I am planning it this; Move all access tables to sql server and then link the tables to access front-end mdb app (using odbc?). Copy the same setup (access front end + sql backend) onto each laptop....

Microsoft Access / VBA

5973

Access Back-End Over the Internet?

by: Raphi | last post by:

Hi, I've been using an Access application I wrote for an office with the front-end stored on all computers and the back-end on one of them serving as an Access file server. Now we're moving to a 2nd office 15 minutes down the road. Only one office will be open at a time, so theoretically it'd be possible to copy the back-end manually every night from one office to another, but frankly, that's pretty annoying.

Microsoft Access / VBA

3933

Jet 4 Replication Service Pack

by: David W. Fenton | last post by:

See: Updated version of the Microsoft Jet 4.0 Service Pack 8 replication files is available in the Download Center http://support.microsoft.com/?scid=kb;en-us;321076 This includes the Jet 4 synchronizer. This allows anyone to do indirect replication, even without

Microsoft Access / VBA

1876

Regarding Replication in DB2 UDB

by: sat | last post by:

Hi Everybody ! I want to know about REPLICATION in DB2 UDB in detail.As i'm going to work on this i would like to know about it.I want to do it on my PC (if possible) before i can implement it on production systems.So,can anyone let me know the SCENARIOS of DB2 UDB REPLICATION in detail.What is replication? what are the steps we need to do while/before/after starting the replication.To be in brief i want to know the implementation and...

DB2 Database

2787

Regarding db2 udb Replication

by: sat | last post by:

Hi All! I have a small doubt in replication.Previously i was working on replication with the databases under the same instance.So it worked fine. Now i'm facing a new problem which is like, now i want the source db to be under one instance and target db to be under another instance. what i have done is i kept the source db(say sample) under same instance (say db2) as it was before.Now i created a new

DB2 Database

1209

Regarding Replication Concept

by: ParasakthiGuru | last post by:

hai, i don't know Replication concept if anybody can know that replication concept pls sent to me replication brief tutorials By Guru

Microsoft SQL Server

4550

SQL Replication Migration from V8 to V9

by: Gert van der Kooij | last post by:

Hi, Our SQL Replication is between DB2 databases on Windows servers. I'm searching for the document which tells me how to migrate our SQL Replication environment from V8 to V9 (we also need to migrate from V7 to V8 but that's fully described so that's no problem). The PDF 'Migrating to Replication Version 9' doesn't contain a description about migrating SQL Replication, only Q replication. I found some links to PDF manuals which should...

DB2 Database

1237

Regarding SQL Replication

by: FM | last post by:

Hello: Question's on replication. My replication-scenario: Server A -source-tables and capture-server Server B -destination-tables with CD tables federated in it and apply-server Inert method: ASNLOAD with crossloader

DB2 Database

1864

Need help regarding replication in MySql database.

by: Abhinay | last post by:

Hi there, I am C++ programer, new in MySql database, I am using linux OS. Is MySql supports pear to pear replication ( I wanted to duplicate data of master database to salve database at run time for each and every transaction ) ? If no then how to achive it ? I know SqlServer provides pear to pear replication and I wanted to know about similar facility in MySql database. your help would make me happy.

MySQL Database

9647

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9492

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10360

Problem With Comparison Operator <=> in G++

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...

C / C++

10163

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

10108

The easy way to turn off automatic updates for Windows 10/11

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,...

Windows Server

9960

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General

7510

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5397

Trying to create a lan-to-lan vpn between two differents networks

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...

Networking - Hardware / Configuration

3668

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP